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

309 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
fandom12211089(None) 
fandoms13229471fandoms
fantom112110801fantom
random92513551random
bandog1038722bandog
candor94516422candor
condom114215362condom
fado87226462fa_do_
fados95620732fa_dos
fanion94514322fanion
fano75831692fan_o_
fanon84619012fan_on
fanos85926502fan_os
fantod102010032fantod
fantoms12189152fantoms
fanum10313442fan_um
fathom1437472fathom
hansom11219152hansom
randoms102112432randoms
ransom82410942ransom
tandem9311402tandem
abandon1045463abandon
ado49146873_a_do_
ados57633513_a_dos
aldol61212333_aldol
anadem939183_anadem
ancon75718233_ancon
and47244173_and__
andro6314163_andro
andros7313303_andros
ands57833613_and_s
anion55028813_anion
annoy869713_annoy
anoa45634473_an_oa
anode65021033_anode
anomy105113393_an_omy
anon46134853_an_on
anyon85615223_anyon
ardor64617863_ardor
atom67824523_a_tom
axiom143913593_axiom
banco94019393banco_
bancos104713893bancos
band76740913band__
banda85223103band_a
bandas95120543bandas
bandbox1943763bandbox
banded105223173banded
bander93928223bander
bandit93821133bandit
bandogs1138363bandogs
bandora1038813bandora
bandore10611633bandore
bands85233423band_s
bandy114824183band_y
banjo143812443banjo_
banjos15378893banjos
bantam10314063bantam
candid104517853candid
candle94321483candle
candors104216763candors
candour104210243candour
candy115119823cand_y
cannon84514443cannon
cannot83616773cannot
canoe75627253can_oe
canon74725303can_on
canso75019403canso_
cansos84915383cansos
cantdog1134573cantdog
canto74931013canto_
canton85722993canton
cantor85621523cantor
cantos84826973cantos
canyon114512033canyon
cardon94120853cardon
carom95025563ca_rom
carrom10513403carrom
condo85322593condo_
condoms124214083condoms
condor94616973condor
condos94322333condos
cundum1136513cundum
czardom2144183czardom
dado67126333da_do_
dados75522433da_dos
dander811222993dander
dandle84218093dandle
dandy104416703dand_y
danio6319783danio_
danios7314603danios
dogdom1186363dogdom
dom69752443___dom
earldom1044583earldom
endow94510983_endow
factor11911453factor
fad77452413fa_d__
faddism14356723faddism
faddy135511623fa_ddy
fade85736343fa_d_e
faded105025243fa_ded
fader94421513fa_der
fades94932863fa_des
fadge104816993fa_dge
fads86939873fa_d_s
faggot1139053faggot
fagot9323403fa_got
falcon11310293falcon
fallow124713853fallow
fan67158863fan___
fancy134615483fan_cy
fane75343573fan__e
fanega1055783fanega
fanes84639893fan_es
fanfic1436313fanfic
fanfold1485373fanfold
fang85432553fan__g
fanga96119623fan_ga
fangas105017193fangas
fanged114318223fanged
fangs96224073fan_gs
fanions103713073fanions
fanjet16311393fanjet
fanned104117473fanned
fanner94218183fanner
fanny114816043fan_ny
fanons96115213fanons
fans76247373fan__s
fantasm1236593fantasm
fantods11177623fantods
fanums1137263fanums
fanwort13310733fanwort
fard85639063fard__
farded114518953farded
fardel104712593fardel
fards96629843fard_s
farm95934533fa__rm
faro76136923fa_ro_
faros85532023fa_ros
farrow12309973farrow
fathoms1537523fathoms
fatso85113493fatso_
fatsos9389423fatsos
favism1437913favism
favor114712453fa_vor
fend84832973fend__
fended114216913fended
fender103718723fender
fends96324973fend_s
fido87726393f_ido_
fidos95819053f_idos
fiefdom1643013fiefdom
filmdom1562943filmdom
find87532603find__
finder104020233finder
finds95424823find_s
fino76034693fin_o_
finos86226953fin_os
fogdog1234223fogdog
fond86330953fond__
fonded115717043fonded
fonder104120063fonder
fondle104412943fondle
fondly13299043fondly
fonds95824823fond_s
fondu96013973fond_u
fondue104510493fondue
fondus105210943fondus
fordo97218653fordo_
freedom1345853freedom
from96923923f__rom
fund85624983fund__
funded114413893funded
funder104016083funder
fundi96814913fund_i
fundic12389083fundic
funds94119253fund_s
fundus10429173fundus
fungo94413133fungo_
fynbos1433283fynbos
gander84322763gander
ganof95420363gan_of
genom83716843gen_om
grandam1139393grandam
gundog935793gundog
hagdon1188283hagdon
halidom1386443halidom
hand86833713hand__
handax1749583handax
handed114919983handed
hander104526433hander
handle104219293handle
handloom1444613handloom
handoff1756483handoff
handout11314103handout
hands95327383hand_s
handsome1447603handsome
handy125520873hand_y
hangdog1343133hangdog
hansoms12238523hansoms
indol63714873_indol
indow95011663_indow
jarldom1743123jarldom
kendo105113223kendo_
kendos114510663kendos
kingdom1543543kingdom
land56337313land__
landau7310613landau
landed84619243landed
lander74028483lander
landform1445223landform
lands65426903land_s
lapdog1034443lapdog
lardon74415063lardon
madam10316223ma_dam
madtom1138023madtom
mandola1039023mandola
mango85724323mango_
mangos94319333mangos
manioc103914823manioc
mano66536813man_o_
manor78023933man_or
manos74933623man_os
mondo85721233mondo_
mondos95217333mondos
nandin7313033nandin
nanism8311203nanism
nom510450643__n_om
noncom1039683noncom
pagandom1443533pagandom
panda85022613pand_a
pandas95521963pandas
pander93725523pander
pandit93820753pandit
pandoor10358583pandoor
pandora1039543pandora
pandore10411853pandore
pandour10408213pandour
pandy115021173pand_y
panto76129413panto_
pantos85222743pantos
pantoum1138703pantoum
papadom1466763papadom
pardon94618733pardon
phantom1436693phantom
radome9511873ra_dome
radon64620503ra_don
rancor8810373rancor
rand55839573rand__
randan7315253randan
randomly1443793randomly
rands65930453rand_s
randy95022083rand_y
ransoms92410163ransoms
rhabdom1543383rhabdom
rondo65218373rondo_
rondos74616733rondos
saintdom1142463saintdom
sand55338473sand__
sandal73317283sandal
sandbox1744803sandbox
sanded84920613sanded
sander74828533sander
sandhi1038193sandhi
sandhog1275453sandhog
sandlot8311693sandlot
sands65228583sand_s
sandworm1446333sandworm
sandy94221133sand_y
sannop837373sannop
santo56227283santo_
santol64515243santol
santos64421833santos
seldom939403seldom
shahdom1643973shahdom
sodom8814913_sodom
stardom1037763stardom
sundog837613sundog
syncom1336093syncom
tandems1037633tandems
tandoor8278563tandoor
tango66921173tango_
tangos74216303tangos
tannoy958353tannoy
tanto55724943tanto_
tardo65321103tardo_
tendon7312033tendon
tondo69718683tondo_
tondos75115923tondos
transom948823transom
tsardom1044483tsardom
tzardom1943733tzardom
undo55620153_undo_
vagrom1235943vagrom
vanda94515923vand_a
vandal103713833vandal
vandas103915993vandas
varoom11411413varoom
vendor10359803vendor
venom103914863ven_om
wand85833883wand__
wander104423713wander
wandle105316663wandle
wands96425483wand_s
wanion93213063wanion
wanton94413813wanton
window1347363window
wisdom1235983wisdom
zander163417113zander

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 Filter1786911127160.266671770.7
2DLD Change Limit1127163095.65619928.6
3Display Results3093090.0933322.6
 (SQL Overall)1786913096.01529707.6
 
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.