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

221 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
fantast1031170(None) 
fantasm1236591fantasm
fantasts1147111fantasts
fantasy1336151fantasy
antas55432032_antas_
faintest1139072faintest
fangas105017192fangas_
fantail10310232fantail
fantasia1197012fantasia
fantasie11117742fantasie
fantasist1288002fantasist
fantasms1345632fantasms
fantastic1446142fantastic
fastest102413722fastest
fattest102913062fattest
mantas85725362mantas_
phantast1346922phantast
aghast105711363_aghast
anas46649863_an_as_
anatase738943_anatase
anenst63514983_anenst
angas65827983_angas_
angst6415493_an_gst
anlas55626933_anlas_
annas55824883_annas_
anoas57226493_anoas_
anta46839583_anta__
antae56828293_anta_e
antepast1048293_antepast
antes56334323_antes_
antis55033313_antis_
ants47243473_ant_s_
antsy85712793_ant_sy
aptest82917513_aptest
artist64125543_artist
attest62618613_attest
autist64324943_autist
avast85519363_a_vast
ballast9313993ballast
bandas95120543bandas_
bantam10314063banta_m
bantams1149063bantams
baptist11311873baptist
canasta938363can_asta
cannas84518403cannas_
canst74932213can__st
cantal84122033canta_l
cantala94114673cantala
cantals93919573cantals
cantata93811813cantata
cantos84826973cantos_
cants77036943cant_s_
cantus85117763cantus_
canvas113813333canvas_
canvass12376873canvass
centas85020703centas_
cineast9310523cineast
contact1144020683contact
contest93523233contest
contrast102614783contrast
daftest11248943daftest
dankest122611673dankest
dentist8316743dentist
dynast1088223dyn_ast
fabbest1438033fabbest
facias113415803facias_
facts107021893fact_s_
faddist12289643faddist
faenas94412763faenas_
faineant1146743faineant
fainest10417703fainest
faintish1446193faintish
faints94818783faint_s_
fairest10412293fairest
faiths124610273faiths_
fajitas1734253fajitas_
falsest10310013falsest
fanatic12610693fanatic
fanciest133612713fanciest
fanegas1145713fanegas_
fanes84639893fan_es_
fanfare1336673fanfare
fanga96119623fanga__
fangs96224073fan_gs_
fanjet16311393fan_jet
fanjets1734803fanjets
fanons96115213fanons_
fanos85926503fan_os_
fans76247363fan__s_
fantails1139693fantails
fantasias1286993fantasias
fantasied1395613fantasied
fantasies1298853fantasies
fantasise1296243fantasise
fantasists1385503fantasists
fantasize2196053fantasize
fantastico1553383fantastico
fantastics1544373fantastics
fantod102010033fant_od
fantods11177623fantods
fantom112110803fant_om
fantoms12189153fantoms
fanums1137263fanums_
fanwise1336633fanwise
fanwort13310733fanwort
farthest1499863farthest
farts88336843fart_s_
fascist1239213fascist
fast77052313f___ast
fasts86429683fast_s_
fatal84819373fa_ta_l
fatalist11314973fa_talist
fates85139233fa_tes_
fatness103311293fatness
fats76252503fa_t_s_
fatso85113493fa_t_so
fattiest113514313fattiest
fattish1359263fattish
fatwas1249053fatwas_
faunas94013633faunas_
fauvist1336663fauvist
favas115618593fa_vas_
fawniest14287443fawniest
feast85932723f__east
featest102715113featest
fetas85624403f_etas_
fincas113512073fincas_
finest94321733fin_est
fittest102510803fittest
flattest1138713flattest
flautas1036153flautas_
flautist1186803flautist
flotas94013003flotas_
flutist102910783flutist
flypast1583753flypast
fondant11311143fondant
fondest11312403fondest
fontal9313143fonta_l
fonts86124753font_s_
frankest1536963frankest
funest94316863fun_est
funfest13348083funfest
funnest102912003funnest
ganjas14149113ganjas_
gantlet83616243gantlet
gauntest936603gauntest
handfast1546733handfast
hansas94616043hansas_
hants86335403hant_s_
infantas11246003infantas_
intact8314663_intact
juntas134210503juntas_
kanas95326913kan_as_
kantar10311153kanta_r
kantars11310033kantars
katas95922093ka_tas_
lactase937953lactase
lambast11129893lambast
lankest112714113lankest
lantana739603lantana
latest63822703la_test
mainmast1245863mainmast
maltase938903maltase
manas76240423man_as_
manat76039983man_a_t
manats84623463manats_
mangas94122923mangas_
manias84029033manias_
mannas85019803mannas_
manta75629903manta__
mantes84430783mantes_
mantis83926033mantis_
mantlet93620993mantlet
mantras93815863mantras_
mantuas93410993mantuas_
nanas55928633nan_as_
natant6318733na_tant
nonpast939033nonpast
pandas95521963pandas_
pangas99921103pangas_
pantalet10415903pantalet
pantos85222743pantos_
pants76536923pant_s_
pastas85422873pastas_
peltast9310513peltast
phantasm1554123phantasm
phantasts1443953phantasts
phantasy1643463phantasy
pintas85021393pintas_
qanat144426843qan_a_t
qanats154112813qanats_
raitas64417673raitas_
rankest112713813rankest
rants55935343rant_s_
saltant7316773saltant
saltest71916513saltest
sanest64426693san_est
sangas75222653sangas_
santos64421833santos_
scantest101710183scantest
sunfast1038503sunfast
tanist6324593tan_ist
tankas104613763tankas_
tannest72617853tannest
tantara72410813tantara
tantras73112093tantras_
tartest72517533tartest
tautest72612443tautest
uncast84215713_uncast
vandas103915993vandas_
vantage11109893vantage
vastest102911513vastest
waniest103819113waniest
wannest103915003wannest
wantage11119623wantage
wants87932213want_s_
wattest102412153wattest
yantras10259003yantras_
yentas94614213yentas_
zaniest163214773zaniest
zanzas1487053zanzas_

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 Filter1786911340270.313570897.8
2DLD Change Limit1340272218.15616432.9
3Display Results2212210.0802762.5
 (SQL Overall)1786912218.54920902.0
 
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.