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

154 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
atavist1031109(None) 
atavism1238031atavism
atavists1137581atavists
activist13109482activist
atavic11189292atavi_c
atavisms1346992atavisms
atavistic1445982atavistic
atheist10314062atheist
atomist92915762atomist
etatist7415032etatist
fatalist11314972fatalist
nativist11118682nativist
satanist8313372satanist
statist7317722statist
tanist6324592_tanist
abatis84317933abatis_
ableist9311773ableist
activism15117083activism
activists1497043activists
advise10139223a_dvise
against838383against
agaves104611513agaves_
ageist7315383a_geist
agist66325583__agist
agonist82615403agonist
akvavit1742943akvavi_t
akvavits1841833akvavits
alarmist1049123alarmist
alist56136783__alist
altoist7313393altoist
altruist857953altruist
amorist9317643amorist
analyst10189323analyst
anapest9311563anapest
animist93815173animist
annalist8413753annalist
aorist64827873a_orist
apiarist10412063apiarist
aquarist171010083aquarist
aquavit1945203aquavi_t
aquavits2043893aquavits
arbalist10313333arbalist
artist64125543a_rtist
assist6314603a_ssist
ataps76414833ata_ps_
ataxia13179593ataxi_a
ataxias14189343ataxias
ataxic15169203ataxi_c
ataxics16196643ataxics
ataxies142410013ataxies
atheism1248523atheism
atheists1138713atheists
athirst1037873athirst
atilt54828473at__ilt
atomise93013823atomise
atomism112610963atomism
atomists102610963atomists
atonalist9411833atonalist
attaint7313473attaint
attest62618613at_test
atticist10811343atticist
attrit6315753attri_t
attrits7310613attrits
aurist65027253a_urist
autarkist1345103autarkist
autist64324943a_utist
avast85519363__avast
aviarist11410113aviarist
aviso85713963__aviso
await85524493awa_i_t
awaits96411953awa_its
botanist10412033botanist
bravest124211753bravest
cabalist12314503cabalist
catalyst1347313catalyst
cladist10311973cladist
czarist18710223czarist
dadaist9310103dada_ist
davit93424593_davi_t
davits104012363_davits
dialist8517763dialist
diarist8517113diarist
dualist8614053dualist
etatism9610293etatism
fantasist1288003fantasist
fatalism13310483fatalism
fatalists12310023fatalists
fauvist1336663fauvist
favism1437913_favism
gravest114011633gravest
hagadist1347603hagadist
halakist15158223halakist
heaviest143210443heaviest
imagist1077333imagist
kabalist14410083kabalist
knavish1743993knavish
lavish124112983_lavish
leaviest112910823leaviest
lutanist8410273lutanist
maist75535683_ma_ist
mavis105622723_mavis_
metalist10519353metalist
nativism13116613nativism
nativists12116253nativists
naturist8410813naturist
onanist7314633onanist
oralist7619633oralist
paganist11411813paganist
papist102618753_papist
pavis106422733_pavis_
pavise114714803_pavise
pianist9615103pianist
racist82822793_racist
rapist82520673_rapist
ravish123414033_ravish
realist73225383realist
sadist74221353_sadist
satanism1039673satanism
satanists948233satanists
satirist8313503satirist
sitarist8315283sitarist
slavish1338233slavish
spaviet123011933spaviet
stagiest91613413stagiest
stalest73720173stalest
stasis63116873stasis_
statism9412283statism
statists8310163statists
staves94525193staves_
staving113915703staving
stylist102110283stylist
suavest10310623suavest
tachist12613293tachist
tacit76333673_taci_t
taint55542283_ta_int
tamest85721293_tamest
tamis76728733_tamis_
tanists7313653_tanists
tapis75028863_tapis_
tatamis939723tatamis_
tavs75630973_tav_s_
taxis126821973_taxis_
theist9314763_theist
totalist8315583totalist
tsarist7712253tsarist
tubist83013163_tubist
twist86820983_t_wist
typist1139823_typist
tzarist1659103tzarist
utopist938693utopist
vitalist11313393vitalist
votarist111012163votarist
waist86132383_wa_ist
waviest134513073_waviest

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.403443402.0
2DLD Change Limit1340271546.14321817.8
3Display Results1541540.0602566.7
 (SQL Overall)1786911546.60627049.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.