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 “supplies” 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
supplies126884(None) 
supples11511281suppl_es
supplied1345991supplied
supplier1246601supplier
suppliers1354481suppliers
applies11311222_applies
buppies133011062bupp_ies
guppies123310522gupp_ies
puppies103212622pupp_ies
resupplies1442412resupplies
sullies74122232su_llies
superlies11314552superlies
supple10410202suppl_e_
suppled1248462suppl_ed
suppler1148432suppl_er
supplest1248952suppl_est
suppling1359042suppling
supposes1238202supposes
surplices1346042surplices
uppiles11208262_uppiles
yuppies14339262yupp_ies
apples104315763_appl_es
applied1247483_applied
applier1137903_applier
appliers1235573_appliers
bubblies1166773bubblies
bullies94121893bu_llies
buppie12288733bupp_ie_
complies14314523complies
cullies94419963cu_llies
cuppier1368323cupp_ier
cuppiest1448203cupp_iest
cupules113210263cupul_es
dapples1238993dappl_es
duopolies1244323duopolies
duperies11312813duperies
eupepsies1344073eupepsies
fipples14298653fippl_es
gullies84717313gu_llies
hippies142813753hipp_ies
hopples142810713hoppl_es
huipiles1344423huipiles
hurlies103315333hu_rlies
implies11312123_implies
koppies153210013kopp_ies
lupulins1044653lupulins
misapplies1643603misapplies
muhlies1238933mu_hlies
murphies1536453murphies
nappies114613403napp_ies
nipples11319663nippl_es
outflies11310153outflies
outlies72421993ou_tlies
pappies103214833papp_ies
plies74526513___plies
polies84034583__polies
poppies102816203popp_ies
popples103011873poppl_es
purples112712833purpl_es
pusslies1036173pusslies
reapplies1344923reapplies
replies94521043_replies
resupplied1542063resupplied
ripples113513293rippl_es
ripplier1234463ripplier
rippliest1334773rippliest
rumples113313133rumpl_es
rumplier1235303rumplier
rumpliest1345313rumpliest
sallies73227813s_allies
samples112815453sampl_es
sapphics1743423sapphics
sapphires1644043sapphires
sappier113613123sapp_ier
sappiest122612583sapp_iest
sawflies1444743sawflies
sicklies14710013sicklies
sillies73425083s_illies
simples113014943simpl_es
simplices1546043simplices
sophies12314623s_ophies
soppier112711583sopp_ier
soppiest122511943sopp_iest
spales84728103s_pal_es
spavies123012953s_pavies
species11314133s_pecies
spies76037623s__p_ies
spiles84227913s_pil_es
splices113914383s__plices
splines94718893s__plines
splits85416413s__plits
spunkies14227593spunkies
spurries102311323spurries
staples93617213stapl_es
steelies8312553steelies
stipples1247023stippl_es
stoolies8311083stoolies
stopples1236953stoppl_es
stupefies1443833stupefies
subfiles131710723subfiles
sublimes12310033su_blimes
sublines10315783su_blines
subplots1255773subplots
suckles134516743suckl_es
sudaries9312753sudaries
sulkies114315763su_lkies
sullied83714483su_llied
sulphides1544693sulphides
sulphids1444373sulphids
sulphites1445683sulphites
sundries9312023sundries
superlie10312123superlie_
supes75628303su_p__es
supines94216383su_pines
supped114415703supp__ed
supper104115433supp__er
suppers113314703supp_ers
supping123814533supp_ing
supplant1247823supplant
supplants1344873supplants
supplely1543063supplely
suppleness1444453suppleness
suppliances17102663suppliances
suppliant1345183suppliant
suppliants1443303suppliants
supplicates1744133supplicates
supply1346893suppl__y
supplying1774043supplying
supports1246513supports
suppose1137973suppose_
supposed1345783supposed
supposer1245593supposer
supposers1344533supposers
suppress1236443suppress
supremes1238363supremes
sureties8316583sureties
surlier72915443su_rlier
surliest82416913su_rliest
surplice1246203surplice
surpliced1444153surpliced
surplus936793surpl_us
surpluses1155433surpluses
surprise1037673surprise
surprises1137433surprises
surprizes2045593surprizes
susliks1136443su_sliks
suspires1038203suspires
swiples12339643swipl_es
swipples1534843swippl_es
tipples112811253tippl_es
topples113111653toppl_es
tumplines1346023tumplines
uglies7412323_u_glies
unpiles92112783_unpiles
updries10209083_updries
uppile10178503_uppile_
uppiled12216593_uppiled
yippies14279293yipp_ies
yuppie13297133yupp_ie_
yuppifies1942693yuppifies

Search took 9 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 Limit1461621607.56319325.9
3Display Results1601600.0632539.7
 (SQL Overall)1786911608.04622208.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.