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 “ruffliest” 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.

71 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
ruffliest155449(None) 
buffiest1657562buff_iest
gruffiest1634532gruff_iest
huffiest1757202huff_iest
puffiest1647322puff_iest
rubbliest1354692rubbliest
ruffles133512272ruffl_es_
rufflier1434012rufflie_r
ruliest72816432ru__liest
rumpliest1345312rumpliest
snuffliest1643502snuffliest
waffliest1844232waffliest
auntliest936323auntliest
bubbliest1254423bubbliest
buffest15298643buff__est
bulliest104314503bu_lliest
burbliest1365593burbliest
burliest103113063bu_rliest
chuffiest2044403chuff_iest
crumbliest1643903crumbliest
crumpliest1644123crumpliest
cuddliest1343333cuddliest
cuffless1634293cuffl_ess
curliest102713123cu_rliest
daffiest1537853daff_iest
draffiest1644363draff_iest
drumliest1235433dru_mliest
duffles14308923duffl_es_
fliest94718433___fliest
fluffiest1434093fluff_iest
gruffest1544593gruff__est
gulfiest1247953gulf_iest
iffiest1337973_iff_iest
jungliest1744923jungliest
miffiest1637143miff_iest
muffles153910453muffl_es_
nubbliest1354363nubbliest
outflies11310153outflies_
puddliest1343693puddliest
raffles133611853raffl_es_
reefiest112811483reef_iest
reflies104418533r_eflies_
riffles133911173riffl_es_
rippliest1334783rippliest
roiliest8312283r_oiliest
rubiest92914423ru__biest
ruddiest10278543ru_ddiest
ruffes124112423ruff__es_
ruffle124111673ruffl_e__
ruffled14369153ruffl_e_d
ruffler13369723ruffl_e_r
rufflers14347193ruffl_ers
rufflike1843253ruffli_ke
ruffling1546093ruffli_ng
rummiest12299353ru_mmiest
runniest82911203ru_nniest
runtiest83014513ru_ntiest
ruralist8311703rurali_st
rushiest113312923ru_shiest
rustiest83116803ru_stiest
ruttiest82712663ru_ttiest
scruffiest1842933scruff_iest
snuffiest15246053snuff_iest
stuffiest15235953stuff_iest
surfiest112414433surf_iest
surliest82416913su_rliest
truffles1485593truffl_es_
tuftiest1138283tu_ftiest
turfiest112410133turf_iest
ugliest8410153_u_gliest
wifeliest1545883wifeliest

Search took 8 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 Filter1786911486410.420425454.8
2DLD Change Limit148641717.47019898.4
3Display Results71710.0302366.7
 (SQL Overall)178691717.92022562.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.