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

116 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
supplied134599(None) 
suppled1248461suppl_ed
supplier1246601supplier
supplies1268841supplies
applied1247482_applied
resupplied1542072resupplied
sullied83714482su_llied
supped114415702supp__ed
supple10410202suppl_e_
suppler1148432suppl_er
supples11511282suppl_es
suppliers1354482suppliers
suppling1359042suppling
supposed1345782supposed
surpliced1444152surpliced
uppiled12216592_uppiled
applier1137903_applier
applies11311223_applies
bullied104514813bu_llied
buppie12288733bupp_ie_
buppies133011063bupp_ies
complied1539683complied
cullied104012353cu_llied
cupeled1257793cupel_ed
cupelled1365743cupelled
cupolaed1342753cupolaed
cupped134413983cupp__ed
cuppier1368323cupp_ier
dappled1336393dappl_ed
dupped124411643dupp__ed
gullied93812063gu_llied
guppies123310523gupp_ies
hoppled15338083hoppl_ed
implied1238623_implied
misapplied1742763misapplied
nippled12307643nippl_ed
plied85118593___plied
poppied11388993popp_ied
poppled11339243poppl_ed
pupped105013273pupp__ed
puppies103212623pupp_ies
purpled12299783purpl_ed
reapplied1443683reapplied
replied103914463_replied
resupplies1442413resupplies
rippled123110273rippl_ed
ripplier1234463ripplier
rumpled123810013rumpl_ed
rumplier1235303rumplier
sallied83316953s_allied
sampled123410793sampl_ed
sapped114422013sapp__ed
sappier113613123sapp_ier
scuppered1643933scuppered
sepaled10510593sepal_ed
sepalled1156903sepalled
sicklied1546583sicklied
sipped113720633sipp__ed
sopped114819903sopp__ed
soppier112711583sopp_ier
spalled103113133s_palled
speiled104412123s_peiled
spelled103714743s_pelled
spied85427713s__p_ied
spiled94621993s_pil_ed
spilled103613623s_pilled
spliced124310593s__pliced
splined105013113s__plined
spoiled104811353s_poiled
stapled103613703stapl_ed
stippled1345303stippl_ed
stoppled1345003stoppl_ed
stupefied1542673stupefied
sublimed1337213su_blimed
suckled144212513suckl_ed
sulked114314703su__lked
sullies74122233su_llies
sulphid1346113sulphi_d
sulphide1444623sulphide
sumpweed1643723sumpweed
supered10316123su_pered
superlie10312123superlie_
superlies11314553superlies
supper104115433supp__er
supping123814533supp_ing
supplant1247823supplant
supplanted15113503supplanted
supplely1543063supplely
supplest1248953supplest
suppliant1345183suppliant
supplicated1843733supplicated
supply1346893suppl__y
supplying1774043supplying
supported1444683supported
suppose1137973suppose_
supposer1245593supposer
supposes1238203supposes
surlier72915443su_rlier
surplice1246203surplice
surplices1346043surplices
surplused1243533surplused
surprised1245313surprised
surprized2144663surprized
suspired1135613suspired
tippled12358393tippl_ed
toppled12348843toppl_ed
tupped114013233tupp__ed
unapplied1443743unapplied
unpiled102312743_unpiled
updried11226473_updried
upped103715163_upp__ed
uppile10178503_uppile_
uppiles11208263_uppiles
yuppie13297133yupp_ie_
yuppies14339263yupp_ies
yuppified2042413yuppified

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.420425454.8
2DLD Change Limit1461621166.86021306.4
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.32624391.3
 
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.