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

103 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
altoists84875(None) 
altoist7313391altoist_
altruists945412altruists
artists74215592art_ists
atomists102610962a_tomists
autists73814852aut_ists
ableists1036543ableists
accosts11107993acco_sts
activists1497043activists
adjoints16103873adjoints
aftosas10147153afto_sas
ageists848493a_geists
agists75713173a__gists
agonists9289833agonists
alarmists1145943alarmists
aldoses8311203aldo_ses
algorisms1246173algorisms
alienists946913alienists
alist56136783al__ist_
allots64019173allo__ts
almost81014433almo_st_
aloins65022203al_oi_ns
alpinists1195793alpinists
altos55822953alto___s
altruisms1144373altruisms
altruist857953altruist_
amorists10411333amorists
anatomists12116753anatomists
animists103010633animists
anoints7311063a_noints
aorists74215833a_orists
aphorists1448263aphorists
appoints1286403appoints
arborists1147453arborists
aroints7313133a_roints
arsonists947413arsonists
artist64125543art_ist_
artiste73813693art_iste
artistes83213343art_istes
assists738473a_ssists
astricts1049463astricts
atavists1137583atavists
atheists1138713atheists
atomises103514403a_tomises
atomisms12269573a_tomisms
atomist92915763a_tomist_
attaints846493attaints
attests7278813a_ttests
atticists1167943atticists
attrits7310613attri_ts
aurists74615783a_urists
autisms94311553aut_isms
autist64324943aut_ist_
automats10410443automats
autopsists1243883autopsists
azotises1737603azotises
banjoists1843253banjoists
baptists1236723bapt_ists
cladists1136723cladists
cultists10107633cult_ists
daltonisms1345163daltonisms
egoists887073_egoists
egotists937063egotists
elegists9128113elegists
elitists848543elitists
entwists1156143entwists
florists1138813florists
flutists11256413flutists
foists95413983__foists
glosts74513813gl_o_sts
halakists16125353halakists
hoists95516023__hoists
intwists1145593intwists
joists134711033__joists
judoists1643653judoists
latests73910313lat_ests
legists899593_legists
lists56628693_l__ists
lookists1245713_lookists
lutists73810273_lutists
lyrists1036963_lyrists
maltoses1039863malto_ses
metrists1039853metrists
motorists1149913motorists
oboists937903_oboists
ologists939443ologists
palmists12268813pal_mists
plenists1038253plenists
poloists10910523poloists
protists10313363protists
rallyists1243333rallyists
retwists1135603retwists
soloists869153soloists
sumoists1046733sumoists
tattooists1092743tattooists
titlists837293titlists
toasts65914993__toasts
toits55327473__toi_ts
twists9549753__twists
ultraists947333ultraists
untwists1144623untwists
utopists1045773_utopists
waitlists1244603waitlists

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.436409841.7
2DLD Change Limit1461621037.34319904.9
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.82522835.9
 
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.