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

270 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
fantoms1218915(None) 
fandoms13229471fandoms
fantods11177621fantods
fantom112110801fantom_
atoms76817562_a_toms
bantams1149062bantams
cantons95221202cantons
cantors94620752cantors
cantos84826972canto_s
factors12912122factors
fandom122110892fandom_
fanions103713072fanions
fanons96115212fan_ons
fanos85926502fan_o_s
fantasm1236592fantasm
fantasms1345632fantasms
fantod102010032fanto_d
fanums1137262fan_ums
fathoms1537522fathoms
hansoms12238522hansoms
madtoms1236922madtoms
pantos85222742panto_s
pantoums1236712pantoums
phantoms1545972phantoms
randoms102112432randoms
ransoms92410162ransoms
santims9312602santims
santols73513322santols
santos64421832santo_s
wantons103713012wantons
actors81016763_actors
altos55822953_alto_s
anatomy1246233_anatomy
anions64123033_anions
annoys967523_annoys
anoas57226493_an_oas
anomy105113393_an_omy
antas55432033_ant_as
antes56334323_ant_es
anthems12309423_anthems
antics84621453_antics
antis55033313_ant_is
antonyms1345873_antonyms
antres65021003_antres
antrums969173_antrums
ants47243473_ant__s
anyons94513503_anyons
atom67824523_a_tom_
atomy107415193_a_tomy
autos56523323_auto_s
axioms15408053_axioms
bancos104713893banco_s
bandogs1138363bandogs
banjoes16317313banjoes
banjos15378893banjo_s
bantam10314063bantam_
banters94623113banters
banties94324763banties
batons85519423ba_tons
bazooms20285383bazooms
bentos86218303bento_s
bottoms1136993bottoms
candors104216763candors
cannons94412883cannons
canoes84725883can_oes
canons85522063can_ons
cansos84915383canso_s
cantals93919573cantals
cantdogs1244043cantdogs
canters94827733canters
canthus1248713canthus
cantles94721413cantles
canto74931013canto__
canton85722993canto_n
cantor85621523canto_r
cants77036943cant__s
cantus85117763cant_us
canyons124511593canyons
captors113914983captors
caroms105619573ca_roms
carroms11512403carroms
cartons94122473cartons
castors94919443castors
centos85920463cento_s
centums11398783centums
chantors133710263chantors
condoms124214083condoms
contos84923233conto_s
customs11348263customs
daltons8310403daltons
danios7314603danio_s
datos65222783da_to_s
dattos74311903datto_s
datums936353da_tums
diatoms1039073diatoms
entomb1037363_entomb
entombs1135613_entombs
factions133013063factions
factious13239243factious
factoid1338693factoid
factoids1446243factoids
factor11911453facto_r
factory15108343factory
factotums1641923factotums
facts107021893fact__s
fados95620733fa_do_s
faggots1234863faggots
fagots1039963fa_gots
fainters11349693fainters
faints94818783faint__s
faiths124610273fait_hs
faitour1034883faitour
faitours1134263faitours
falcons1239123falcons
fallows133713973fallows
falters103916473falters
famous11412393fa_mous
fanatics1367183fanatics
fancies124018783fancies
fanegas1145713fanegas
fanes84639893fan__es
fanfics1535173fanfics
fanfold1485373fanfold
fanfolds15104073fanfolds
fangas105017193fan_gas
fangs96224073fan__gs
fanion94514323fanio_n
fanjets1734803fanjets
fanners103914653fanners
fannies103415643fannies
fano75831693fan_o__
fanon84619013fan_o_n
fans76247373fan___s
fantail10310233fantail
fantails1139693fantails
fantast10311703fantast
fantasts1147113fantasts
fantasy1336153fantasy
fanum10313443fan_um_
fanwort13310733fanwort
fanworts1446103fanworts
farms106324953fa__rms
faros85532023fa_ro_s
farrows13259783farrows
farts88336843fart__s
fastens105511753fastens
fasts86429683fast__s
fastuous1145143fastuous
fates85139233fa_t_es
fathom1437473fathom_
fatness103311293fatness
fats76252503fa_t__s
fatsoes10379423fatsoes
fatsos9389423fa_tsos
fattens105111713fattens
fatties103018203fatties
fatuous1037783fatuous
fatwas1249053fa_twas
favisms1535443favisms
favors124211403fa_vors
fetors91014473f_etors
finos86226953fin_o_s
flattops1344553flattops
foetors1039763foetors
fonts86124753font__s
frontons1136503frontons
functors1335743functors
fungoes11388813fungoes
fungous11367433fungous
futons93911513f_utons
fynbos1433283fynbo_s
ganofs104010293gan_ofs
gators74115833ga_tors
genoms94412483gen_oms
gentoos838633gentoos
grantors93810353grantors
hansom11219153hansom_
hantles104117513hantles
hants86335403hant__s
intomb1036403_intomb
intombs1144153_intombs
janitors1536853janitors
jatos125116823ja_to_s
juntos134110843junto_s
kantars11310033kantars
lactams1136953lactams
laptops1166603laptops
lentos65317403lento_s
lintols7339553lintols
madtom1138023madtom_
maintops1244403maintops
maltols939403maltols
mangoes104316133mangoes
mangos94319333mango_s
maniocs113611443maniocs
manitos9314053manito_s
manitous1039173manitous
manors84420883man_ors
manos74933623man_o_s
mantas85725363mant_as
mantels94515043mantels
mantes84430783mant_es
mantids103113623mantids
mantis83926033mant_is
mantles94820703mantles
mantrams12288963mantrams
mantras93815863mantras
mantuas93410993mantuas
mentors9314993mentors
nanisms938833nanisms
noms65636403__n_oms
noncoms1139203noncoms
panties94230933panties
panto76129413panto__
pantoum1138703pantoum
pants76536923pant__s
partons94620513partons
pastors94119003pastors
patois84319363pa_tois
phantom1436693phantom_
pintoes95117713pintoes
pintos86021293pinto_s
pontons93315553pontons
puntos85915793punto_s
ragtops1035453ragtops
rancors9811373rancors
random92513553random_
ransom82410943ransom_
ranters73323643ranters
rants55935343rant__s
raptors94213353raptors
ratos55528763ra_to_s
rattons73815323rattons
saintdoms1242493saintdoms
sanctums1244013sanctums
sanious7514103sanious
sannops936693sannops
santimi938793santimi
santimu938563santimu
santirs7312963santirs
santo56227283santo__
santol64515243santo_l
santoor737433santoor
santoors837633santoors
santour737373santour
santours837183santours
santurs7310763santurs
sartors7314973sartors
syncoms1435943syncoms
tandems1037633tandems
tangos74216303tango_s
tannoys1055553tannoys
tanto55724943tanto__
tantras73112093tantras
tantrums1045113tantrums
tattoos738643tattoos
tautogs875413tautogs
toms68343493___toms
transoms1048933transoms
varooms1248883varooms
venoms114211213ven_oms
wanions104011373wanions
wanters104420093wanters
wanton94413813wanto_n
wants87932213want__s
wontons103310533wontons
xanthoma2043973xanthoma
xanthomas2143643xanthomas
xanthous1846643xanthous
yantras10259003yantras

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.420425454.8
2DLD Change Limit1340272706.76619808.9
3Display Results2702700.0932903.2
 (SQL Overall)1786912707.27924548.8
 
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.