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 “fold” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

269 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
fold8652894(None) 
bold75432811bold
cold77338771cold
folds95221691folds
folk116021541folk
fond86330951fond
food86830571food
ford86835491ford
gold65430161gold
hold86235061hold
mold76034331mold
old47033471_old
sold54837411sold
told56132201told
wold85429071wold
acold86214932acold
ahold94714252ahold
auld54125362auld
bald76432902bald
bifold1237222bifold
bod67055552bo_d
bola66035562bola
bolds85825282bolds
bole66448692bole
boll65634752boll
bolo65535952bolo
bolt66254172bolt
bond75334362bond
clod76124612clod
cod69660132co_d
coed77140542coed
col59360352col_
cola66541392cola
colds85726972colds
cole66956112cole
coled85540762coled
cols66553082cols
colt67158242colt
coly96940532coly
cord76740922cord
could86517712could
dol47150652dol_
dole56550002dole
doled75430912doled
doll56632492doll
dols56943052dols
dolt56649422dolt
eld46733802_eld
enfold10137612enfold
fad77452422f_ad
fall75535312fall
falx147120782falx
fard85639062fard
fauld95214492fauld
fed76548362f_ed
feed84538902feed
felid94717172felid
fell76833072fell
felt75146932felt
fend84832972fend
feod815523002feod
feud86523022feud
fid76847702f_id
field95015322field
fil65447152fil_
fila74729142fila
file75446652file
filed95331902filed
fill75540202fill
film94828182film
filo76034292filo
fils75838702fils
find87532612find
fiord94313342fiord
fjeld16465582fjeld
fjord16477022fjord
fled85429772fled
floc95922122floc
floe76129772floe
flog85523892flog
flood95215602flood
flop96925452flop
flow105924922flow
flu66530212f_lu
fly97124952f_ly
foal76630922foal
foaled104515962foaled
foals85721692foals
foam97127172foam
fob86748332fo_b
fobs96034272fobs
foci94521012foci
foe66350812fo_e
foes76543442foes
fog76945562fo_g
fogs87035002fogs
fogy115923182fogy
foh98135892fo_h
fohn106116552fohn
foil76433912foil
foiled104618402foiled
foils85025812foils
foin77231562foin
folded114212792folded
folder104317542folder
foldup1233812foldup
foley115222302foley
folia83618932folia
folic105319322folic
folio83820882folio
folks126017122folks
folky159214712folky
folly115022602folly
fon66352272fo_n
fonds95824822fonds
fondu96013972fondu
fons76943892fons
font77143752font
foods95924162foods
fool75330592fool
fooled104317822fooled
fools86824202fools
foot76248012foot
fop86743702fo_p
fops96532682fops
for66952072fo_r
fora75937392fora
forb97131332forb
fordo97218652fordo
fords95328182fords
fore78351472fore
fork115930942fork
form95836872form
fort76456442fort
foss76431642foss
fou66743782fo_u
foul77027582foul
fouled104315972fouled
fouls87221432fouls
found94917842found
four76226862four
fowl105723632fowl
fowled133914102fowled
fowls115518892fowls
fox136737862fo_x
foxed165115212foxed
foxy176517752foxy
foy96044262fo_y
foys105628292foys
fozy197017162fozy
frond95316342frond
fud76335162f_ud
full75229152full
fund85624982fund
geld65828432geld
gild65526522gild
goad66830982goad
god57449802go_d
golds75421312golds
golf85731182golf
good66531802good
gowd96519982gowd
held85330402held
hod76852472ho_d
hoed87837982hoed
holds94623242holds
hole77553392hole
holed95634132holed
holk116027942holk
holm95628112holm
holp95727552holp
hols76946292hols
holt77852582holt
holy106333432holy
hood85132332hood
infold10128162infold
jole117233822jole
jolt116639122jolt
kola85124972kola
kolo87026232kolo
load56730602load
loid55531502loid
loll46128382loll
lord55032082lord
loud55228042loud
meld75830472meld
mild75330862mild
mod69054412mo_d
mol56654592mol_
mola66035632mola
molds85324832molds
moldy115014652moldy
mole66251832mole
moll66735702moll
mols65948572mols
molt66356162molt
moly96031912moly
mood76332062mood
mould86015752mould
nod47549572no_d
nolo46229312nolo
od39255252_o_d
odd57725462_odd
olds55926582_olds
oldy85316852_oldy
ole37155212_ole
oud47439082_oud
plod76723272plod
pod66351492po_d
pol56449382pol_
pole65951302pole
poled84934842poled
poll66332132poll
polo66236632polo
pols66044562pols
poly96235152poly
pond75530492pond
pood75934322pood
refold103812112refold
road56332112road
rod47953902ro_d
role45851822role
rolf75134872rolf
roll46331652roll
rood56733002rood
scold85414862scold
sild55030592sild
sod46053712so_d
sol37256622sol_
sola45541862sola
soldi65717202soldi
soldo67116562soldo
sole46053672sole
soled65835172soled
soli46637012soli
solid65025082solid
solo45538942solo
sols45448162sols
sord56237202sord
toad55830182toad
tod49457082to_d
toed56137042toed
tola45236332tola
tole46052902tole
toled65934922toled
toll45535262toll
tolu45529152tolu
unfold10179702unfold
upfold12124952upfold
veld85323202veld
void86220572void
vole75236982vole
voled95323722voled
volt76439532volt
weld84727732weld
wild85126522wild
woad85523942woad
woald94813072woald
wolds95420182wolds
wolf105729562wolf
wood85329382wood
word89832002word
world96915362world
would95513152would
yald86920612yald
yeld811423872yeld
yod77545512yo_d
yolk116218992yolk
yond86122312yond

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 Filter178691298721.516117870.1
2DLD Change Limit298722695.9535018.0
3Display Results2692690.406662.6
 (SQL Overall)1786912697.87522690.9
 
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.