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

293 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
toucan83819(None) 
toucans937581toucans
glucan936182glucan
soucar839322soucar
soudan73210352soudan
toecap1037322toecap
tolan55124012to_lan
toman75724052to_man
tomcat101013452tomcat
touch106519392touc_h
touche114916172touche
touchy145010502touchy
anuran64313243anuran
aoudad835043aoudad
ashcan1135843ashcan
bobcat12411253bobcat
bogan87519003bo_gan
boucle103712783boucle
boudin9412373boudin
bourn75518483bou_rn
bouton8311533bouton
bowman13129853bowman
boxcar1734753boxcar
brucin1049133brucin
buran75225303_buran
can57760143___can
cancan10314103cancan
coca88030643co_ca_
cocain101315013co_cain
cocas95926573co_cas
coccal9310223coccal
cooncan1147233cooncan
corban10314693corban
cotan71521783co_tan
couch125320113couc_h
couchant1549053couchant
cougar958783cougar
coupon102810993coupon
courant9317973courant
courlan9117763courlan
cousin8517163cousin
cowman13910373cowman
crucian1146283crucian
dolman95312403dolman
douce85518423douc_e
douche124613223douche
doula65717773doula_
doulas75114993doulas
douma85817703douma_
doumas95314813doumas
doura66518663doura_
dourah10479813dourah
douras75016723douras
ducal84816423_ducal
ducat86225903_ducat
eolian6312593eolian
eonian6311833eonian
faucal11339963faucal
focal104917673fo_cal
foeman11311233foeman
furan84320013_furan
glucans1045293glucans
glycan1234903glycan
goban84414073go_ban
gossan747233gossan
gowan95415743go_wan
guan55325583_gu_an
hogan97817703ho_gan
honan85319773ho_nan
houdah1335173houdah
human102716033_human
jordan1468063jordan
joual12311653jou_al
koan85425033ko__an
lauan55216793lau_an
leucin839113leucin
loan47436453lo__an
loca65527683lo_ca_
local74820273lo_cal
lochan1139093lochan
logan68123283lo_gan
longan75612363longan
loran55925093lo_ran
louche115212663louche
louden73711793louden
louma76213633louma_
loumas84812333loumas
loupen84510293loupen
moan65832023mo__an
mobcap1444113mobcap
morgan9311373morgan
mouch124715803mouc_h
moulin8313283moulin
mourn77215013mou_rn
mouton8410853mouton
mucin93116823_mucin
nonfan948293nonfan
nonman8412363nonman
nougat74712653nougat
noun45724183nou__n
nounal639813nounal
oca56731733_o_ca_
ocas66729633_o_cas
ocean71212963_ocean
octan71313483_octan
oilcan837793oilcan
orca65522773_orca_
orcas75918623_orcas
orcin72716573_orcin
organ6915393_organ
ouch95724633_ouc_h
ourang73311063_ourang
outman83115033_outman
outran63218893_outran
pecan91919033_pecan
potman102813573potman
pouch124617083pouc_h
pouchy16538663pouchy
quean143612843_quean
roan47234203ro__an
rodman949713rodman
roman75424823ro_man
rouche114714313rouche
rouen54920903rou_en
rowan85418733ro_wan
scan65530453__scan
siccan1037593siccan
soca66330053so_ca_
socas74026183so_cas
socman1039813socman
solan55328153so_lan
soldan73511853soldan
soman75024903so_man
soucars938423soucars
soudans8309353soudans
soupcon1144163soupcon
soutane7312063soutane
sovran937153sovran
sowcar1135863sowcar
stoical9310283stoical
stouten7307333stouten
taipan82410663taipan
tampan102512323tampan
tan37167573t___an
tarpan82814293tarpan
tartan64217513tartan
tarzan152910753tarzan
tauon54816583tau_on
tauten64311893tauten
taxman15328613taxman
teopan839353teopan
teuch105214853teuc_h
than76128773t__han
theca103311453theca_
thecae11299653thecae
thecal113310303thecal
thousand1242823thousand
thuja1535213thuja_
thujas1634433thujas
thuya1135583thuya_
thuyas1234773thuyas
tical76021493t_ical
tincal83913363tincal
tinman82411143tinman
tipcat10312653tipcat
titan53318173t_itan
titian62512663titian
titman82711003titman
toad55830183to__ad
toccata1144943toccata
toccate1138773toccate
tocsin8311003tocsin
today96416953to_day
toea46732333to_ea_
toeas55726423to_eas
toecaps1135553toecaps
toga57027413to_ga_
togae67020113to_gae
togas67823003to_gas
tokay125513053to_kay
token95419313to_ken
tola45236333to_la_
tolane64316583to_lane
tolans64319273to_lans
tolar55524113to_lar
tolas54532773to_las
tollman935863tollman
tomans85419133to_mans
tombac12258883tombac
tombak14237753tombak
tombal102311023tombal
tomcats11127773tomcats
tomcod1135783tomcod
ton310265103to___n
tonal53724303to_nal
tonga65619693tonga_
tongas74315523tongas
tongman1037573tongman
toon47740633to__on
topaz16315323to_paz
topcoat1179313topcoat
topical1139953topical
tora47545993to_ra_
torah87125273to_rah
toras55540373to_ras
torc66333353torc__
torch107420933torc_h
torchon1237363torchon
torchy14549533torchy
torcs75123763torc_s
torn46044253to__rn
torta55925353torta_
tortas64918253tortas
torten65314353torten
torula6610393torula_
torulae758553torulae
torulas759853torulas
total55321823to_tal
touched134914963touched
toucher124814353toucher
touches125118343touches
touching143211343touching
touchpad1643173touchpad
touchup1443833touchup
tough97321993tou_gh
toughen11329203toughen
toughs105414993toughs
toughy135911083toughy
toupee8316133toupee
tour45530383tou__r
touraco945363touraco
toured74216153toured
tourer64115073tourer
touring82915193touring
tours55325893tou_rs
touse55430673tou_se
toused74122013toused
touses64229673touses
tousing82916993tousing
tousle64514653tousle
tout46753823tou__t
touted74419743touted
touter63821033touter
touting84118453touting
touts54830393tou_ts
touzle15429003touzle
town76928703to__wn
toxical1637643toxical
toxicant1746293toxicant
toxin124716713to_xin
toyon86715673to_yon
trapan82412973trapan
trepan82511673trepan
trocar848773trocar
truant6315783tru_ant
truce75118693truc_e
truced95312053truced
truces84916333truces
trucing103211843trucing
truck116115463truc_k
truckman1643153truckman
trucks124711973trucks
tsuba745563tsuba_
tuba65422363t_uba_
tubae74716643t_ubae
tubal75517203t_ubal
tubas75119583t_ubas
tuchun1145443t_uchun
tuck104626573t_uc_k
tucks114721123t_ucks
tufa75016613t_ufa_
tufas85314383t_ufas
tun35845193t_u__n
tuna45127843t_una_
tunas54224123t_unas
turban8310483turban
turn46330393t_u_rn
tympan13257013tympan
ulan46527393__ulan
utopian9126273utopian
vocab12409973vo_cab
vocal104715643vo_cal
volcano1244613volcano
vouch134611903vouc_h
voudon1035873voudon
wiccan1335033wiccan
woman105818003wo_man
youpon11366003youpon
yourn87512773you_rn
yuan76120013_yu_an
yuca95716723_yuca_
yucas106013913_yucas
yulan8411493_yulan

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162935.42320784.8
3Display Results2932930.0763855.3
 (SQL Overall)1786912935.87530415.5
 
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.