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

143 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
unfolds1114680(None) 
enfolds11136251enfolds
infolds11137021infolds
unfold10179701unfold_
unmolds10135741unmolds
upfolds13133751upfolds
enfold10137612enfold_
fanfolds15104072fanfolds
folds95221692__folds
infold10128162infold_
pinfolds1445142pinfolds
refolds11298952refolds
tenfolds1244412tenfolds
unbolts9247802unbolts
unfolded1338312unfolded
unfolder12216582unfolder
unfolders1344722unfolders
unfond10149112unfond_
unhoods1137502unhoods
unloads8278522unloads
unmold9148312unmold_
unrolls797792unrolls
unsold71410512unsold_
untold7149682untold_
upfold12124952upfold_
upholds13135242upholds
affords1435023affords
aholds10469483_aholds
anoles64827433an_oles
beholds1336423beholds
bifold1237223bifold_
bolds85825283__bolds
colds85726973__colds
cuckolds1743003cuckolds
enfolded1345433enfolded
enfolder1286153enfolder
enfolders1395093enfolders
engilds974863engilds
enols54718403en_ol_s
enrolls7108093enrolls
enrols61213383enrol_s
eyefolds1542623eyefolds
fanfold1485373fanfold_
fold86528943__fold_
folks126017123__folks
fonds95824823__fonds
foods95924163__foods
fords95328183__fords
fungoids1343993fungoids
golds75421313__golds
holds94623243__holds
indoles83716363indoles
indols74714203indol_s
infalls1038943infalls
infields1244013infields
inflows1335523inflows
infolded1375663infolded
infolder1256433infolder
infolders1385173infolders
informs1248073informs
infos84311673info__s
inroads837043inroads
insoles73516243insoles
kinfolks1453013kinfolks
knolls10367413kn_olls
kobolds1474343kobolds
mangolds1235193mangolds
manifolds1583673manifolds
menfolks1742903menfolks
molds85324833__molds
nods55838223_n_o_ds
nolos54423353_n_olos
olds55926573___olds
onefold1144493onefold_
onloads8246673onloads
oxfords1842893oxfords
pinfold1336233pinfold_
refold103812113refold_
remolds10299703remolds
scolds95011233_scolds
snoods74312453sn_oods
snools65715883snool_s
tenfold1145713tenfold_
twofolds1541613twofolds
unbales92914863unbales
unbelts9237663unbelts
unbends10236993unbends
unbinds10267353unbinds
unbolt83013893unbol_t
unboxes16208303unboxes
unbuilds1143153unbuilds
uncles8317163un_cles
unclogs1036803unclogs
unclouds1144883unclouds
uncocks1537233uncocks
uncoils979533uncoils
uncorks1337443uncorks
uncos74117033unco__s
undocks1436163undocks
undoers82910583undoers
undoes73917403undo_es
unfed94614223unf_ed_
unfelt92413463unfel_t
unfits93910293unf_its
unfixes17238113unfixes
unfoiled12249723unfoiled
unfolding1436063unfolding
unfound11127393unfound
unfrees1048643unfrees
unfrocks1753843unfrocks
unfurls1035573unfurls
ungirds9105303ungirds
ungodly1244473ungodly
unhands1137773unhands
unhelms1234223unhelms
unholy1238163unhol_y
unhood1039233unhood_
unhooks1436413unhooks
uniforms1355043uniforms
unions64216753unio_ns
unipods1095703unipods
unleads8228623unleads
unload73010803unload_
unlocks1337063unlocks
unmolded1237453unmolded
unmoors945903unmoors
unpiles92112783unpiles
unrobes9269733unrobes
unroll61210073unrol_l
unroofs1035783unroofs
unroots738563unroots
unrounds9145573unrounds
unsells73210773unsells
unsolder937213unsolder
unsolders1064693unsolders
unsolid8138373unsolid
unwinds11286733unwinds
unyokes1466733unyokes
upflows1543513upflows
upfolded1542883upfolded
uphold12126903uphold_
uploads10266503uploads
wolds95420183__wolds

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 Filter1786911340270.410435831.7
2DLD Change Limit1340271435.95022525.5
3Display Results1431430.0632269.8
 (SQL Overall)1786911436.42327820.5
 
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.