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

153 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
atomists10261096(None) 
atomises103514401atomises
atomisms12269571atomisms
atomist92915761atomist_
agonists9289832agonists
altoists848752alto_ists
amorists10411332amorists
anatomists12116752anatomists
animists103010632animists
aorists74215832a_orists
apomicts1444192apomicts
atavists1137582atavists
atheists1138712atheists
atomics113110852atomi_cs
atomies93918362atomi_es
atomise93013822atomis_e
atomised11278832atomised
atomiser10268152atomiser
atomisers11255452atomisers
atomism112610962atomis_m
atomistic1347772atomistic
atomizes192711432atomizes
gnomists1145472gnomists
utopists1045772utopists
ableists1036543ableists
abomasus1242853abomasus
activists1497043activists
admits9411413a_dmi_ts
adonises92611433adonises
ageists848493a_geists
agists75713173a__gists
agonises92613163agonises
agonist82615403agonist_
agonistes10266263agonistes
alarmists1145943alarmists
altoist7313393alto_ist_
altruists945413altruists
amiss75823073a__mis_s
amorist9317643amorist_
anatomises1297363anatomises
anatomist11119263anatomist_
animisms12328393animisms
animist93815173animist_
anoints7311063ano_ints
anomies93316993anomi_es
aorist64827873a_orist_
aphorists1448263aphorists
apomict1349053apomict_
apomixes1934853apomixes
apomixis1942923apomixis
arborists1147453arborists
aroints7313133aro_ints
arsonists947413arsonists
artists74215593a_rtists
assists738473a_ssists
atavisms1346993atavisms
atavist10311093atavist_
atheisms1346923atheisms
atheist10314063atheist_
atomic104115603atomi__c
atomical1248903atomical
atomicity1645513atomicity
atomising1247993atomising
atomize183111823atomi_ze
atomized20279323atomized
atomizer19298533atomizer
atomizers20265553atomizers
atoms76817563atom___s
atonalists1048493atonalists
atonias73315993atoni_as
atonics93613713atoni_cs
atonies75320953atoni_es
atopies92816433atopi_es
atropisms1347113atropisms
attaints846493attaints
attests7278813at_tests
atticists1167943atticists
attrits7310613attri_ts
aurists74615783a_urists
autists73814853a_utists
automatists13125933automatists
automats10410443autom_ats
autonomists1355163autonomists
autopsists1243883autopsists
azotises1737603azotises
bemists113410703_bemists
bromisms1436403bromisms
canoeists1147163canoeists
canonists1158513canonists
catmints1236663cat_mints
chemists152710323chemists
chymists18285603chymists
cosmists1237993cosmists
egoists887073ego_ists
egotists937063egotists
fatalists12310023fatalists
florists1138813florists
foists95413983_fo_ists
gnomist1049133gnomist_
hoists95516023_ho_ists
holists104413963_holists
intimists1147493intimists
ironists839293ironists
itemises1087693itemises
joists134711033_jo_ists
lookists1245713lookists
mists76633903___mists
momisms10308223_momisms
monists93614783_monists
motorists1149913motorists
nativists12116253nativists
naturists947513naturists
nomisms11268743_nomisms
oboists937903obo_ists
odists749853__odists
ologists939443ologists
omits75018263__omi_ts
optimists1345293optimists
otocysts1343503otocysts
palmists12268813palmists
parodists1248513parodists
promises122916763promises
protists10313363protists
sarodists1056593sarodists
satanists948233satanists
satirists958923satirists
slalomists1283313slalomists
sodomists1255923sodomists
statists8310163statists
stockists15194563stockists
stylists11207023stylists
sumoists1046733sumoists
tachists1348183tachists
tamises92715973_tamises
tanists7313653_tanists
tattooists1092743tattooists
theists1039153_theists
toasts65914993_to_asts
toits55327473_to_i_ts
tomcats11127773_tomcats
tomtits937243_tomtits
topmasts1244973_topmasts
totemists1146373totemists
tourists838313_tourists
tubists9288323_tubists
twists9549753_t_wists
typists1236173_typists
utmosts934593ut_mosts
utopisms1245413utopisms
utopist938693utopist_
violists1137663violists
vomits112610923_vomi_ts
zootomists2144433zootomists

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621536.94021060.8
3Display Results1531530.0632428.6
 (SQL Overall)1786911537.42324072.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.