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

189 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
fascist123921(None) 
fascism1436441fascism
fascists1336611fascists
assist6314602_assist
bassist9312742bassist
casuist9411302casuist
faddist12289642faddist
fanciest133612712fanciest
fasces114914542fasces_
fascia1148702fasci_a
fasciae1247522fasciae
fascial1258302fascial
fascias1258412fascias
fasciate1347562fasciate
fascine12510582fascine
fascisms1545662fascisms
fascistic1644592fascistic
fastest102413722fastest
fauvist1336662fauvist
narcist9512442narcist
racist82822792ra_cist
abscise1145953abscise
accost101112263_accost
ageist7315383_ageist
agist66325583_a_gist
alist56136783_a_list
aorist64827873_aorist
artist64125543_artist
ascent84519653_ascent
asci66519143_asci__
ascot76522513_asc_ot
ascots85312513_ascots
ascus75013583_ascus_
ashiest10313953_ashiest
aspis74618143_aspis_
aspish114810333_aspish
assists738473_assists
aurist65027253_aurist
autist64324943_autist
baptist11311873baptist
basest84720493bas_est
basics104915123basics_
basis75429863bas_is_
bassists1037183bassists
cambist13312113cambist
cassis84818853cassis_
casuists1036523casuists
cist67244963___cist
classist104010383classist
coassist10298803coassist
cosmist11311333cosmist
dadaist9310103dadaist
dashiest12311113dashiest
dashis104414393dashis_
desist74818813des_ist
easiest72318773easiest
fabbest1438033fabbest
fabulist1347673fabulist
faces106439433fa_ces_
facet106038523fa_c_et
facets116316653fa_cets
facia103218463fa_ci_a
faciae112913413fa_ciae
facial113615633fa_cial
facias113415803fa_cias
facies113921593fa_cies
facile112514883fa_cile
facing125321573fa_cing
fact97142543fa_c__t
facts107021893fa_cts_
faddiest1338113faddiest
faddish15359003faddish
faddism14356723faddism
faddists13235543faddists
faeces114713123faeces_
faggiest132910183faggiest
fainest10417703fainest
faint85837063fa__int
fairest10412293fairest
fairish1338993fairish
falces115216003falces_
falsest10310013falsest
famish14311843fa_mish
fancied133310603fancied
fancier123412063fancier
fancies124018783fancies
fancify1834983fancify
fancily1538253fancily
fantast10311703fantast
fanwise1336633fanwise
farces115223323farces_
farci105919313farci__
farcie114816473farci_e
farcies125317883farcies
farcing133514003farcing
fasciated1546133fasciated
fascicle1554633fascicle
fasciitis1443543fasciitis
fascinate1447763fascinate
fascines13310143fascines
fascitis1346013fascitis
fashes124524023fashes_
fashing144918793fashing
fashion1337843fashion
fast77052313fa___st
fasting114522833fasting
fasts86429683fas_ts_
fatalist11314973fatalist
fattest102913063fattest
fattiest113514313fattiest
fattish1359263fattish
fauces114916153fauces_
faucet115816553fauc_et
faucets12578443faucets
faucial1257323faucial
fauvism1545223fauvism
fauvists1443843fauvists
favism1437913fa_vism
fawniest14287443fawniest
feist86230073f__eist
feudist1137573feudist
fiascos12124743fiascos_
fideist1139753fideist
fiscalist1446573fiscalist
fiscs105311883fisc_s_
fishiest14310453fishiest
fist76248423f___ist
flashiest1557983flashiest
flautist1186803flautist
florist10314243florist
flutist102910783flutist
foist85730973f__oist
frescoist1444123frescoist
fuguist1136073fuguist
fussiest112910493fussiest
fustiest113014573fustiest
gashest114813413gashest
gaslit7513503gasli_t
gassiest93212523gassiest
harpist12312353harpist
hashish1238353hashish
hastiest112916493hastiest
insist6314513ins_ist
laciest93819033la_ciest
laicise939333laicise
laicism1138243laicism
lassis65216703lassis_
maist75535683ma__ist
mascot104016073masc_ot
mascots113910343mascots
masochist1645583masochist
massiest103314423massiest
miscast11312423miscast
narcism1188733narcism
narcists1078113narcists
nascent9610523nascent
nastiest83615953nastiest
oasis56422553oas_is_
paciest112917803pa_ciest
palmist112814343palmist
papist102618743pa_pist
pastiest103319543pastiest
pastis84924323pastis_
prefascist1753143prefascist
raciest92820013ra_ciest
racism103214193ra_cism
racists92613323ra_cists
rapist82520673ra_pist
rashest103916873rashest
raspiest10311273raspiest
raspish1298103raspish
resist64524533res_ist
sacrist9315423sacrist
sadist74221353sa_dist
sassiest83413613sassiest
sauciest10310973sauciest
schist11312653__schist
shist84829613__shist
tachist12613293tachist
tacit76333673ta_ci_t
tanist6324593ta_nist
tastiest83216633tastiest
tsarist7712253tsarist
vastest102911513vastest
vastiest112713073vastiest
waist86132383wa__ist
washiest14310403washiest
waspiest1338813waspiest
waspish1586923waspish

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.403443402.0
2DLD Change Limit1340271896.94019312.2
3Display Results1891890.0603150.0
 (SQL Overall)1786911897.40324137.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.