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

151 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
altoist731339(None) 
altoists848751altoists
alist56136782al__ist
almost81014432almo_st
altos55822952alto_s_
altruist857952altruist
artist64125542art_ist
atomist92915762a_tomist
autist64324942aut_ist
ableist9311773ableist
accost101112263acco_st
activist13109483activist
actorish1349443actorish
actors81016773actors_
adjoint15108283adjoint
adroit7518793adroi_t
aftmost1244973aftmost
aftosa996573afto_sa
ageist7315383a_geist
agist66325583a__gist
agonist82615403agonist
alarmist1049123alarmist
albeit8314343albei_t
aldols7109713aldols_
aldose7311093aldo_se
algoid83011473algoi_d
algorism1147353algorism
algors7312553algors_
alibis8311073alibis_
alienist8411993alienist
alit46155693al__i_t
allods73615083allods_
allot54933873allo__t
allots64019173allots_
allows94517683allows_
alloys94014563alloys_
aloes54933673al_oes_
aloft8423433al_o_ft
aloin55227423al_oi_n
aloins65022203al_oins
alpinist1059153alpinist
altars64518153altars_
alters64924223alters_
alto47831263alto___
altruism1055373altruism
altruists945413altruists
alts46639903alt__s_
amorist9317643amorist
anatomist11119263anatomist
animist93815173animist
anoint6423633a_noint
antis55033313ant_is_
antsiest8511463antsiest
aorist64827873a_orist
aphorist13412513aphorist
appoint11612483appoint
aptest82917513apt_est
arborist10411613arborist
aroint6328153a_roint
arsonist8412013arsonist
artiest73121993artiest
artiste73813693art_iste
artists74215593art_ists
artsiest879653artsiest
assist6314603a_ssist
astonish1148453astonish
astrict9614793astrict
atavist10311093atavist
atheist10314063atheist
athirst1037873a_thirst
atilt54828473a_t_ilt
atomise93013823a_tomise
atomism112610963a_tomism
atomists102610963a_tomists
atoms76817563a_toms_
attaint7313473attaint
attest62618613a_ttest
atticist10811343atticist
attrit6315753attri_t
attrits7310613attrits
aurist65027253a_urist
autism83815333aut_ism
autists73814853aut_ists
autoing8314043autoing
automat9414873automat
autopsist1145783autopsist
autopsy1244373autopsy
autos56523323auto_s_
azotise1637073azotise
banjoist1745143banjoist
baptist11311873bapt_ist
cladist10311973cladist
cultist91412713cult_ist
daltonism1245573daltonism
daltons8310403daltons_
egoist7612283_egoist
egotist8411273egotist
elegist81311973elegist
elitist7414913elitist
entwist1048803entwist
florist10314243florist
flutist102910783flutist
foist85730973__foist
glost65422933gl_o_st
halakist15158223halakist
hoist86433213__hoist
intwist1038043intwist
joist125125653__joist
judoist1545633judoist
latest63822703lat_est
lathiest11312663lathiest
lathis95516173lathis_
latish92416173lat_ish
legist71315253_legist
list47055343_l__ist
lookist1139563_lookist
lost47951493_l_o_st
lutist64317553_lutist
lyrist9312293_lyrist
maltiest102916193maltiest
maltols939403maltols_
maltose939793malto_se
metrist9317063metrist
moist76033583__moist
motorist10314413motorist
oboist8312683_oboist
ologist8313833ologist
palmist112814343pal_mist
paltriest1138603paltriest
patois84319363patois_
plenist9314333plenist
poloist91016323poloist
protist9320223protist
rallyist1145363rallyist
retwist1039483retwist
saltest71916513salt_est
saltiest83117723saltiest
saltish10312163salt_ish
soloist7915893soloist
sumoist9311613sumoist
tattooist994813tattooist
titlist7312923titlist
toast55831013__toast
toit46353063__toi_t
toits55327473__toits
tost48351923__to_st
twist86820983__twist
ultraist849633ultraist
untwist1047713untwist
utopist938693_utopist
waitlist1147743waitlist

Search took 10 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.810220606.2
2DLD Change Limit1340271518.86015127.2
3Display Results1511510.0463282.6
 (SQL Overall)1786911519.71618391.4
 
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.