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

180 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
supplier124660(None) 
suppler1148431suppl_er
supplied1345991supplied
suppliers1354481suppliers
supplies1268831supplies
applier1137902_applier
cuppier1368322cupp_ier
ripplier1234462ripplier
rumplier1235302rumplier
sappier113613112sapp_ier
soppier112711582sopp_ier
supper104115432supp__er
supple10410202suppl_e_
suppled1248462suppl_ed
supples11511282suppl_es
suppling1359042suppling
supposer1245592supposer
surlier72915442su_rlier
applied1247483_applied
appliers1235573_appliers
applies11311213_applies
auntlier834903auntlier
bubblier1184473bubblier
bullier94116433bu_llier
bumpier13359203bump_ier
buppie12288733bupp_ie_
buppies133011063bupp_ies
burblier1255603burblier
burlier93514413bu_rlier
complier14310253complier
crumplier1543783crumplier
cuddlier1234013cuddlier
cupeler1177483cupel_er
cupeller1256103cupeller
cupper124313863cupp__er
curlier93314183cu_rlier
dimplier1336673dimplier
dippier123111393dipp_ier
dumpier12409653dump_ier
espalier1036363espalier
fusilier1135423fusilier
gappier12369843gapp_ier
gulpier1046953gulp_ier
guppies123310523gupp_ies
happier143312033happ_ier
hippier143212103hipp_ier
hoppier143110703hopp_ier
humpier143110723hump_ier
jumpier18317943jump_ier
junglier1644303junglier
lippier112710573lipp_ier
loppier11369723lopp_ier
lumpier113410143lump_ier
nappier114411173napp_ier
nippier11319833nipp_ier
nubblier1254413nubblier
outlier72216143ou_tlier
palier85023563__palier
pappier103511593papp_ier
peppier10268323pepp_ier
pimplier1445413pimplier
plier75221283___plier
puddlier1234213puddlier
pulpier1148623pulp_ier
puppies103212613pupp_ies
purpler11289273purpl_er
quippier2133773quippier
replier94214973_replier
resupplied1542063resupplied
resupplies1442413resupplies
rippler113210103rippl_er
rubblier1244913rubblier
rufflier1434013rufflier
rulier65016353ru__lier
sallier73320423s_allier
sampler113212013sampl_er
sapper103822353sapp__er
sapphire1543803sapphire
scalier94316913s_calier
scupper1367423scupp__er
seemlier1035193seemlier
seepier92912013seep_ier
shalier103116423s_halier
shapelier1444463shapelier
shellier1138393shellier
shoalier1137073shoalier
sicklier1457213sicklier
sillier74017593s_illier
simpler112910863simpl_er
sipper103920993sipp__er
slier54827243s___lier
slippier1256533slippier
sloppier1255703sloppier
smellier1036793smellier
snappier1266213snappier
snarlier8278183snarlier
snippier1255793snippier
snufflier1543303snufflier
soapier93411713soap_ier
soupier93111753soup_ier
spacier114011633s_pacier
spaller92713473s_paller
speller95415143s_peller
spelter94113703s_pelter
spicier115112463s_picier
spier75728033s__p_ier
spikier13369983s_pikier
spiller92914333s_piller
spinier93715163s_pinier
spirier93214073s_pirier
splicer114710523s__plicer
spoiler93310683s_poiler
sprier84119063s__prier
spumier1137903s_pumier
spunkier14235823spunkier
spurrier10297693spurrier
squallier1844363squallier
stapler93913633stapl_er
steelier839183steelier
stillier868823stillier
stippler1235543stippl_er
stubblier1343203stubblier
studlier935473studlier
stumpier1255883stump_ier
stupefier1442653stupefier
sublimer1237613su_blimer
subtiler10208573subtiler
subtler92910843subtl_er
suckier133613973su_ckier
suckler133413093suckl_er
sudsier868783su_dsier
sugarier937393sugarier
sulker104015923su__lker
sulkier113811963su_lkier
sullied83714483su_llied
sullies74122233su_llies
sultrier837773sultrier
sumpter1138873sump_ter
sunnier73412153su_nnier
super74924483su_p__er
superber1239693superber
superior10310883superior
superlie10312123superlie_
superlies11314553superlies
superliner1249203superliner
supped114415703supp__ed
suppers113314703supp__ers
supping123814533supp_ing
supplant1247823supplant
supplanter14113673supplanter
supplely1543063supplely
supplest1248943supplest
suppliant1345183suppliant
supply1346893suppl__y
supplying1774043supplying
supporter1344513supporter
suppose1137973suppose_
supposed1345783supposed
supposers1344533supposers
supposes1238203supposes
supremer1246483supremer
surfier102613543su_rfier
surplice1246203surplice
surpliced1444153surpliced
surplices1346043surplices
surpriser1144613surpriser
suspire937803susp_ire
sutler63718393su_tl_er
swirlier1135213swirlier
tippier113210543tipp_ier
tippler11348343tippl_er
uglier748953_u_glier
upper93714263_upp__er
uppile10178503_uppile_
uppiled12216593_uppiled
uppiles11208263_uppiles
yuppie13297133yupp_ie_
yuppies14339263yupp_ies
zappier20458373zapp_ier
zippier20308193zipp_ier

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.436409841.7
2DLD Change Limit1461621806.40622816.4
3Display Results1801800.0802250.0
 (SQL Overall)1786911806.92225814.9
 
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.