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 “truffles” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

160 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
truffles148559(None) 
ruffles133512271_ruffles
truffes1356771truff_es
truffle1384891truffle_
truffled1563991truffled
duffles14308922_duffles
muffles153910452_muffles
raffles133611842_raffles
riffles133911162_riffles
ruffes124112422_ruff_es
ruffle124111672_ruffle_
ruffled14369152_ruffled
ruffler13369722_ruffler
rufflers14347192_rufflers
scuffles16287862scuffles
shuffles17297782shuffles
snuffles14318412snuffles
souffles14298122souffles
trifles103814822tr_ifles
truckles14319382truckles
truffe1276232truff_e_
trundles9278482trundles
baffles153710683_baffles
bouffes15388633bouff_es
coffles152610003_coffles
crumbles14329683crumbles
crumples14348813crumples
cuffless1634293_cuffless
drumbles13277723drumbles
duffels14296453_duffels
duffle13368533_duffle_
etouffees1561273etouffees
griffes14367923griff_es
gruffed1544943gruff_ed
gruffer1475793gruff_er
gruffest1544593gruff_est
gruffier1544703gruffier
gruffiest1634533gruffiest
gruffly17413893gruffl_y
gruffness1692743gruffness
gruffs13337453gruff__s
grumbles13288873grumbles
gruntles9287233gruntles
kerfuffles195773kerfuffles
muffle14339643_muffle_
muffled16377783_muffled
muffler15398343_muffler
mufflers16316003_mufflers
piffles15368763_piffles
pouffes15408123pouff_es
prefiles133113443prefiles
profiles133211233profiles
purfles122511843_purfles
raffle123910703_raffle_
raffled14429083_raffled
raffler13339223_raffler
rafflers14317363_rafflers
refiles104122423_refiles
riffle124210233_riffle_
riffled14338603_riffled
riffler13328353_riffler
rifflers14336443_rifflers
rifles94217703_r_ifles
rubbles113715113_rubbles
rubles83921703_ru_bles
ruckles133414603_ruckles
ruddles92813873_ruddles
ruffe114713813_ruff_e_
ruffed134312743_ruff_ed
rufflier1434013_rufflier
ruffliest1554493_ruffliest
ruffly15336673_ruffl_y
ruffs114516743_ruff__s
rules55234253_ru__les
rumbles114018393_rumbles
rumples113313133_rumples
rundles83214713_rundles
runkles114111943_runkles
rustles73416413_rustles
rutiles74315843_rutiles
scuffle15266893scuffle_
scuffled17256203scuffled
scuffler16286703scuffler
scufflers17285033scufflers
shuffle16276923shuffle_
shuffled18296243shuffled
shuffler17306803shuffler
shufflers18265153shufflers
skiffles18265713skiffles
snaffles14246043snaffles
sniffles14257723sniffles
snuffle13267833snuffle_
snuffled15277033snuffled
snuffler14317413snuffler
snufflers15285223snufflers
souffle13306803souffle_
souffled15276193souffled
struggles11255283struggles
stuffless1543543stuffless
taffies133012693t_affies
tartuffes1551623tartuff_es
toffees13327083t_offees
toffies133210213t_offies
tousles74113933tou_sles
touzles16359223tou_zles
trachles13311753trachles
traffics1644183traffics
tramples122610203tramples
trauchles1445493trauchles
treacles1039703treacles
treadles939703treadles
trebles9311443tr_ebles
treddles1036263treddles
trembles1237353trembles
trestles83012553trestles
trickles143013763trickles
trifle94012883tr_ifle_
trifled113711963tr_ifled
trifler103912153tr_ifler
triflers113110213tr_iflers
trindles93211683trindles
triples94616873tr_iples
troffer13125863troff_er
troffers14125433troffers
troubles1057203troubles
truceless11235393truceless
truces84916333tru__ces
truckle13358863truckle_
truckled15327313truckled
truckler14297453truckler
trucklers15295583trucklers
trudges9339993tru_dges
trueblues1142053trueblues
trues54925323tru___es
trulls64110283tru__lls
trundle8307873trundle_
trundled10306393trundled
trundler9256153trundler
trundlers10215003trundlers
trunnels844513trunnels
trusses73813643tru_sses
trustees8339323trustees
trusties82712853trusties
trustless955953trustless
truthless1244033truthless
tubules9310233t_ubules
tuffet122612083t_uff_et
tuffets13266523t_uffets
tuffs115118263t_uff__s
tuilles72411923t_uilles
tules54532793t_u__les
tulles63218893t_u_lles
tumbles113816023t_umbles
turfless1135533t_urfless
turtles72914343t_urtles
tussles737833t_ussles
unmuffles1772063unmuffles
unruffled1672923unruffled
waffles16329983_waffles
whiffles2034263whiffles

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621607.48619524.7
3Display Results1601600.0632539.7
 (SQL Overall)1786911607.98522378.3
 
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.