Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “rufflike” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
rufflike184325(None) 
gulflike1643452gulflike
rooflike1534622rooflike
rubylike1753352rubylike
ruffle124111672ruffl__e
rufflier1434012rufflier
ruffling1546092ruffling
ruglike1236282ru_glike
runelike1236032runelike
rushlike1534332rushlike
surflike1535932surflike
turflike1534442turflike
auntlike1234983auntlike
budlike14257873bu_dlike
bushlike1734963bushlike
calflike1735153calflike
clifflike2141903clifflike
cufflink20152883cufflink
cufflinks21141673cufflinks
cultlike1434933cultlike
cuplike1537213cu_plike
drumlike1543793dru_mlike
duffle13368533duffl__e
dunelike1335303dunelike
dustlike1335363dustlike
elflike1435133_elflike
fruitlike1642853fruitlike
fumelike1735223fumelike
fuselike1535673fuselike
gumlike14317403gu_mlike
gutlike12308653gu_tlike
hooflike1834853hooflike
husklike1433613husklike
hutlike14349063hu_tlike
jutelike1935333jutelike
leaflike1534713leaflike
lifelike15166223lifelike
loftlike1534393loftlike
muffle14339643muffl__e
muffling1765503muffling
nunlike11258073nu_nlike
nutlike113110113nu_tlike
offline1345783_offline
pumplike1834373pumplike
puslike1347563pu_slike
pusslike1434033pusslike
quaylike2434143quaylike
raffle123910703raffl__e
raffling1567063raffling
rashlike1535793rashlike
ratlike113912353r_atlike
raylike14269253r_aylike
reedlike1336213reedlike
riblike1337333r_iblike
riffle124210233riffl__e
riffling1556113riffling
ringlike1336243ringlike
rocklike1335903rocklike
rodlike1288263r_odlike
roofline1136193roofline
rootlike1236613rootlike
ropelike14157853ropelike
roselike12169183roselike
ruffe114713813ruff___e
ruffian1344133ruff_ian
ruffing143210843ruff_ing
ruffled14369153ruffl_ed
ruffler13369723ruffl_er
rufflers14347193rufflers
ruffles133512273ruffl_es
ruffliest1554493ruffliest
ruffly15336673ruffl__y
ruralise839643ruralise
ruralite848963ruralite
ruralize1739233ruralize
serflike1536273serflike
suchlike1735123suchlike
suffice15197573suff_ice
sufflate1456183sufflate
suitlike1236313suitlike
sunlike112310573su_nlike
truffle1384893truffl__e
tubelike1436093tubelike
tublike1337083tu_blike
tusklike1133583tusklike
unalike11311533_unalike
unlike102614063_u_nlike
urnlike1136713_urnlike
waiflike1834573waiflike
wifelike18135253wifelike
wolflike1834063wolflike

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.440406115.9
2DLD Change Limit146162916.28023274.2
3Display Results91910.0303033.3
 (SQL Overall)178691916.75026472.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.