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

104 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
upfolds1313375(None) 
unfolds11146801unfolds
upfold12124951upfold_
upholds13135241upholds
enfolds11136252enfolds
folds95221692__folds
infolds11137022infolds
refolds11298952refolds
unfold10179702unfold_
unmolds10135742unmolds
upflows1543512upflows
upfolded1542882upfolded
uphold12126902uphold_
uploads10266502uploads
affords1435023affords
aholds10469483_aholds
apods86316343ap_o_ds
beholds1336423beholds
bifold1237223bifold_
bolds85825283__bolds
colds85726973__colds
cuckolds1743003cuckolds
cupfuls1444343cupful_s
cupolas11277753cup_olas
enfold10137613enfold_
ephods1238363epho_ds
euploids1157243euploids
eyefolds1542623eyefolds
fanfolds15104073fanfolds
fold86528943__fold_
folks126017123__folks
fonds95824823__fonds
foods95924163__foods
fords95328183__fords
golds75421313__golds
holds94623243__holds
infold10128163infold_
kobolds1474343kobolds
molds85324833__molds
olds55926573___olds
opioids1036523opioids
oxfords1842893oxfords
pinfolds1445143pinfolds
plods85719293_plo_ds
pods76540153_p_o_ds
poles75351003_p_oles
polis74731163_p_olis
polls74627723_p_olls
polos76129913_p_olos
pols66044563_p_ol_s
polys105718763_p_olys
ponds85323403_p_onds
poods85124753_p_oods
pools74427703_pool_s
prods85523553_pro_ds
proles84627203_proles
refold103812113refold_
remolds10299703remolds
scolds95011233_scolds
spools85115913spool_s
tenfolds1244413tenfolds
twofolds1541613twofolds
unbolts9247803unbolts
unfolded1338313unfolded
unfolder12216583unfolder
unfolders1344723unfolders
unfond10149113unfond_
unhoods1137503unhoods
unloads8278523unloads
unmold9148313unmold_
unrolls797793unrolls
unsold71410513unsold_
untold7149683untold_
upbinds12234813upbinds
upboils1184703upboils
upbows1384683upbo_ws
upbuilds1341753upbuilds
upcoils1184933upcoils
updos8389513updo__s
upends9438763up_ends
upfield1343033upfield_
upflow1433523upf_low
upfolding1642943upfolding
upgirds11103073upgirds
upheld12115563upheld_
uphills1295233uphills
uphoards1443763uphoards
upholder1444083upholder
upholders1543643upholders
uplands1036943uplands
upload9257783upload_
uppiles11208263uppiles
uproars986453uproars
uproots937143uproots
upsends10265293upsends
upsoars985413upsoars
uptalks1333723uptalks
uptilts934733uptilts
uptoss836093upto_ss
uptowns12194343uptowns
upwards13135963upwards
upwells12244303upwells
upwinds13224223upwinds
wolds95420183__wolds

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271046.64320175.7
3Display Results1041040.0303466.7
 (SQL Overall)1786911047.07925242.4
 
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.