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

228 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
toucans93758(None) 
toucan838191toucan_
glucans1045292glucans
soucars938422soucars
soudans8309352soudans
toecaps1135552toecaps
tolans64319272to_lans
tomans85419132to_mans
tomcats11127772tomcats
touches125118342touches
anurans73810553anurans
aoudads973763aoudads
ashcans1235183ashcans
bobcats1335993bobcats
bogans95714813bo_gans
boucles113113003boucles
boudins10311313boudins
bourns84114063bou_rns
boutons9310783boutons
boxcars1834773boxcars
brucins1158003brucins
burans85019303_burans
cancans11311873cancans
cans65050853___cans
cocains111313923co_cains
cocas95926573co_ca_s
cooncans1246273cooncans
corbans11313173corbans
cotans81317923co_tans
couchant1549053couchant
couches144020473couches
cougars1038443cougars
coupons112710563coupons
courant9317973courant
courants10310803courants
courlans10117613courlans
cousins9516003cousins
crucians1245293crucians
dolmans10479683dolmans
douches134315233douches
doulas75114993doula_s
doumas95314813douma_s
dourahs11487253dourahs
douras75016723doura_s
ducats95011763_ducats
faucals12326563faucals
furans94515953_furans
glucan936183glucan_
glycans1344233glycans
gobans94412043go_bans
gossans836783gossans
gowans105512293go_wans
guans64419443_gu_ans
hogans105914313ho_gans
honans94814503ho_nans
houdahs1434243houdahs
humans112312433_humans
jordans1566833jordans
jouals1338923jou_als
koans95818623ko__ans
lauans65113533lau_ans
leucins938103leucins
loans56026463lo__ans
locals83714503lo_cals
lochans1248833lochans
logans76319063lo_gans
longans84510813longans
lorans65117603lo_rans
loudens8368053loudens
loumas84812333louma_s
moans74624373mo__ans
mobcaps1543463mobcaps
morgans10310123morgans
mouches143815963mouches
moulins9312703moulins
mourns84111013mou_rns
moutons9410313moutons
mucins102712513_mucins
nonfans1037533nonfans
nougats8427413nougats
nouns56717313nou__ns
ocas66729633_o_ca_s
oceans81211003_oceans
octans81411143_octans
oilcans936813oilcans
orcas75918623_orca_s
orcins83313433_orcins
organs7912913_organs
ouches114322183_ouches
ourang73311063_ourang
ourangs8318503_ourangs
outmans92413283_outmans
pecans101515833_pecans
pouches144116743pouches
queans153110753_queans
roans54926443ro__ans
romans84620243ro_mans
rouches124217893rouches
rouens64814443rou_ens
rowans95715343ro_wans
scans74625103__scans
socas74026183so_ca_s
solans64122493so_lans
soldans83210403soldans
somans84619303so_mans
soucar839323souca_r
soudan73210353soudan_
soupcons1244373soupcons
soutane7312063soutane
soutanes8312933soutanes
sovrans1036483sovrans
sowans94215893so_wans
sowcars1236013sowcars
stoutens8255273stoutens
taipans9269553taipans
tampans113310983tampans
tans46154823t___ans
tarpans92513533tarpans
tartans72615823tartans
tarzans16329923tarzans
tauons63412673tau_ons
tautens7317843tautens
teopans939203teopans
thousand1242823thousand
thousands1342313thousands
thujas1634433thuja_s
thuyas1234773thuya_s
ticals83214713t_icals
tincals93610643tincals
tipcats1137103tipcats
titans63414913t_itans
titians72710453titians
toads65621073to__ads
toccata1144943toccata
toccatas1243743toccatas
toccate1138773toccate
tocsins939963tocsins
todays10458103to_days
toeas55726423to_ea_s
toecap1037323toeca_p
togas67823003to_ga_s
tokays13397773to_kays
tokens104711563to_kens
tolan55124013to_lan_
tolane64316583to_lane
tolanes74216313to_lanes
tolars64817943to_lars
tolas54532773to_la_s
toman75724053to_man_
tombacs13248443tombacs
tombaks15246863tombaks
tomcat101013453tomca_t
tomcods1234873tomcods
tongas74315523tonga_s
tons46553053to___ns
toons55027533to__ons
topcoats1245193topcoats
torahs95115643to_rahs
toras55540373to_ra_s
torches123715443torches
torchons1337503torchons
torcs75123763torc__s
tortas64918253torta_s
torulas759853torula_s
totals63115163to_tals
touch106519393touc__h
touche114916173touc_he
touched134914963touched
toucher124814353toucher
touchers133611213touchers
touching143211343touching
touchpads1742523touchpads
touchup1443833touchup
touchups1543083touchups
touchy145010503touc_hy
toughens12286723toughens
toughs105414983tou_ghs
toupees938513toupees
touraco945363touraco
touracos1045313touracos
tourers73512743tourers
touring82915193touring
tourings9277373tourings
tours55325893tou__rs
touses64229673tou_ses
tousing82916993tousing
tousles74113933tousles
touters74018353touters
touting84118453touting
touts54830393tou__ts
touzles16359223touzles
towns86018883to__wns
toxicant1746293toxicant
toxicants1843833toxicants
toxins133314283to_xins
toyons95512133to_yons
trans54933043t__rans
trapans92812463trapans
trepans92311593trepans
trocars959043trocars
truant6315783tru_ant
truants738163tru_ants
truces84916333truc_es
trucing103211843trucing
trucks124711973truc_ks
tubas75119583t_uba_s
tuchuns1233983t_uchuns
tucks114721123t_uc_ks
tufas85314383t_ufa_s
tunas54224123t_una_s
tuns45138663t_u__ns
turbans939563turbans
turns55623243t_u_rns
tympans14236813tympans
ulans54921303__ulans
utopians1094903utopians
vocabs13336313vo_cabs
vocals113811583vo_cals
volcano1244613volcano
volcanos1344733volcanos
vouches153914113vouches
voudons1135323voudons
wiccans1434603wiccans
womans114613653wo_mans
youpons12265983youpons
yuans84613323_yu_ans
yucas106013913_yuca_s
yulans958673_yulans

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.393454684.5
2DLD Change Limit1340272286.54620474.6
3Display Results2282280.0932451.6
 (SQL Overall)1786912287.03225411.1
 
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.