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

151 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
upfold1212495(None) 
unfold10179701unfold
upfolds13133751upfolds
uphold12126901uphold
bifold1237222bifold
enfold10137612enfold
fold86528942__fold
infold10128162infold
refold103812112refold
unfolds11146802unfolds
unfond10149112unfond
unmold9148312unmold
unsold71410512unsold
untold7149682untold
upfield1343032upfield
upflow1433522upflow
upfolded1542882upfolded
upheld12115562upheld
upholds13135242upholds
upload9257782upload
acold86214933_acold
afford1346493afford
ahold94714253_ahold
apod78123183ap_o_d
behold1247343behold
bold75432813__bold
cold77338773__cold
cuckold1643723cuckold
cupful1356423cupful_
cupfuls1444343cupfuls
cupola10317693cup_ola
enfolds11136253enfolds
ephod1139123epho_d
euploid1038963euploid
eyefold1443343eyefold
fanfold1485373fanfold
folds95221693__folds
folk116021543__folk
fond86330953__fond
food86830573__food
ford86835493__ford
fourfold1542213fourfold
gold65430163__gold
hold86235063__hold
infolds11137023infolds
kobold1365963kobold
mold76034333__mold
old47033473___old
onefold1144493onefold
opioid9310083opioid
outsold8109073outsold
outtold8107603outtold
oxford1763663oxford
pinfold1336233pinfold
plod76723273_plo_d
pod66351493_p_o_d
pol56449383_p_ol_
pole65951303_p_ole
poled84934843_p_oled
poll66332133_p_oll
polo66236633_p_olo
pols66044563_p_ols
poly96235153_p_oly
pond75530493_p_ond
pood75934323_p_ood
pooed85226243_pooed
pool65835953_pool_
pooled94619813_pooled
pools74427703_pools
prod76129503_pro_d
prole74527793_prole
proud84615483_proud
puffed153510603puffed
pyoid11513763_pyoid
refolds11298953refolds
remold93412973remold
resold73915363resold
retold73013753retold
scold85414863_scold
sixfold1842723sixfold
sold54837413__sold
spool75219043spool_
spooled104613523spooled
spools85115913spools
tenfold1145713tenfold
told56132203__told
trifold1136243trifold
tufoli933973tufoli
twofold1442283twofold
unbolt83013893unbolt
unfed94614223unf_ed
unfelt92413463unfelt
unfoiled12249723unfoiled
unfolded1338313unfolded
unfolder12216583unfolder
unfound11127393unfound
unholy1238163unholy
unhood1039233unhood
unload73010803unload
unmolds10135743unmolds
unroll61210073unroll
unsolid8138373unsolid
upbind11246313upbind
upboil1096453upboil
upboiled13194853upboiled
upboils1184703upboils
upbore10247883upbore
upbound12134813upbound
upbow1245613upbo_w
upbows1384683upbows
upbuild1243003upbuild
upcoil10126193upcoil
upcoiled13215183upcoiled
upcoils1184933upcoils
updo76712893updo__
updos8389513updo_s
updove1234483updove
upend85011043up_end
upflowed1742893upflowed
upflows1543513upflows
upfolding1642943upfolding
upfront1246973upfront
upgird10103933upgird
uphill11106173uphill
uphoard1344573uphoard
upholder1444083upholder
uphove1436133uphove
upland938863upland
uploads10266503uploads
upmost1068193upmost
upo58925863up_o__
upon65817583up_o_n
upped103715163up_ped
uppile10178503uppile
uppiled12216593uppiled
uproar8106933uproar
uproot8314123uproot
uprose82311483uprose
upsend9356883upsend
upsoar8105693upsoar
upstood1044243upstood
uptalk1234653uptalk
uptilt8410803uptilt
uptore8279453uptore
uptorn8268093uptorn
uptoss836093uptoss
uptown11274963uptown
upward12147163upward
upwell11285803upwell
upwind12255823upwind
wold85429073__wold

Search took 6 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 Filter1786911127160.420425454.8
2DLD Change Limit1127161515.28321335.6
3Display Results1511510.0463282.6
 (SQL Overall)1786911515.74931082.1
 
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.