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

163 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
fantasm123659(None) 
fantasms1345631fantasms
fantast10311701fantast
fantasy1336151fantasy
antas55432032_antas_
bantam10314062banta_m
bantams1149062bantams
fangas105017192fangas_
fantail10310232fantail
fantasia1197012fantasia
fantasie11117742fantasie
fantasts1147112fantasts
fantom112110802fant_om
fantoms12189152fantoms
mantas85725362mantas_
phantasm1554122phantasm
anas46649863_an_as_
anatase738943_anatase
angas65827983_angas_
anlas55626933_anlas_
annas55824883_annas_
anoas57226493_anoas_
anta46839583_anta__
antae56828293_anta_e
antes56334323_antes_
anthem113410343_anthem
antis55033313_antis_
antrum8611313_antrum
ants47243473_ant_s_
antsy85712793_ant_sy
autism83815333_autism
bandas95120543bandas_
baptism1337803baptism
cannas84518403cannas_
cantal84122033canta_l
cantala94114673cantala
cantals93919573cantals
cantata93811813cantata
cantos84826973cantos_
cants77036943cant_s_
cantus85117763cantus_
canvas113813333canvas_
canvass12376873canvass
centas85020703centas_
facias113415803facias_
facts107021893fact_s_
faddism14356723faddism
faenas94412763faenas_
faintest1139073faintest
faintish1446193faintish
faints94818783faint_s_
faiths124610273faiths_
fajitas1734253fajitas_
fanatic12610693fanatic
fandom122110893fan_dom
fandoms13229473fandoms
fanegas1145713fanegas_
fanes84639893fan_es_
fanfare1336673fanfare
fanga96119623fanga__
fangs96224073fan_gs_
fanons96115213fanons_
fanos85926503fan_os_
fans76247363fan__s_
fantails1139693fantails
fantasias1286993fantasias
fantasied1395613fantasied
fantasies1298853fantasies
fantasise1296243fantasise
fantasist1288003fantasist
fantasize2196053fantasize
fantastic1446143fantastic
fantod102010033fant_od
fantods11177623fantods
fanum10313443fan__um
fanums1137263fanums_
fanwise1336633fanwise
farts88336843fart_s_
fascism1436443fascism
fastest102413723fastest
fasts86429683fast_s_
fatal84819373fa_ta_l
fatalism13310483fa_talism
fates85139233fa_tes_
fathom1437473fa_thom
fatness103311293fatness
fats76252503fa_t_s_
fatso85113493fa_t_so
fattest102913063fattest
fattish1359263fattish
fatwas1249053fatwas_
faunas94013633faunas_
fauvism1545223fauvism
favas115618593fa_vas_
favism1437913fa_vism
fetas85624403f_etas_
fincas113512063fincas_
flautas1036153flautas_
flotas94013003flotas_
flotsam1244613flotsam
fontal9313143fonta_l
fonts86124753font_s_
ganjas14149113ganjas_
giantism1155383giantism
hansas94616043hansas_
hants86335403hant_s_
infantas11246003infantas_
juntas134210503juntas_
kanas95326913kan_as_
kantar10311153kanta_r
kantars11310033kantars
katas95922093ka_tas_
lactam10310943lacta_m
lactams1136953lactams
lactase937953lactase
lantana739603lantana
maltase938903maltase
manas76240423man_as_
manats84623463manats_
mangas94122923mangas_
manias84029033manias_
mannas85019803mannas_
manta75629903manta__
mantes84430783mantes_
mantis83926033mantis_
mantram114011603mantram
mantrams12288963mantrams
mantras93815863mantras_
mantuas93410993mantuas_
nanas55928633nan_as_
nanism8311203nan_ism
pandas95521963pandas_
pangas99921103pangas_
pantos85222743pantos_
pantoum1138703pantoum
pants76536923pant_s_
pastas85422873pastas_
phantasma1653003phantasma
phantasms1643533phantasms
phantast1346923phantast
phantasy1643463phantasy
pintas85021393pintas_
qanats154112813qanats_
raitas64417673raitas_
rants55935343rant_s_
sangas75222653sangas_
santims9312593santims
santos64421833santos_
sarcasm1136693sarcasm
syntagm1343303syntagm
tankas104613763tankas_
tantalum1044323tantalum
tantara72410813tantara
tantras73112093tantras_
tantrism1048373tantrism
tantrum946683tantrum
vandas103915993vandas_
vantage11109893vantage
wantage11119623wantage
wants87932213want_s_
yantras10259003yantras_
yentas94614213yentas_
zanzas1487053zanzas_

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271636.50020619.5
3Display Results1631630.0632587.3
 (SQL Overall)1786911636.71926594.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.