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

347 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
tarzans1632992(None) 
tarpans92513531tarpans
tartans72615821tartans
tarzan152910751tarzan_
azans146516882_a_zans
hazans183411652ha_zans
hazzans18215782hazzans
parians93519732parians
partans94418282partans
sarans64224432sar_ans
taipans9269552taipans
tampans113310982tampans
tarmacs1138322tarmacs
tarns56433952tar__ns
tarpan82814292tarpan_
tarpons92612212tarpons
tarsals72512602tarsals
tartan64217512tartan_
tartana73010192tartana
tartanas8258892tartanas
tartars73313402tartars
tazzas1436282tazza_s
trans54933042t_r_ans
trapans92812462trapans
turbans939562turbans
alans55636173_a_lans
araks94820883_ar_aks
arcana8912583_arcana
arcane81216743_arcane
areas55935773_area_s
arenas65021993_arenas
argals75517713_argals
argons75018203_argons
arhats9312973_arhats
arias55438023_aria_s
arpens84814823_arpens
arrant6623253_arrant
arras55626133_arra_s
arrays95311683_arrays
arsons63917213_arsons
ataghans1244263ataghans
atamans9710433atamans
atmans84413963_atmans
avians93711563_avians
azan136521783_a_zan_
azons146518253_a_zons
baizas173810823baiza_s
banians9312033banians
banyans1237913banyans
banzais1837163banzais
barcas101016603barca_s
barchans1588683barchans
bargains1178643bargains
barman103519703barman_
barns76335143bar__ns
barons85025383bar_ons
barrens94414323barrens
bartizans2053703bartizans
baryons121010473baryons
bazars174613113ba_zars
brans75437433_br_ans
brazas175812433braza_s
brazens18418713brazens
burans85019303bur_ans
caftans12179443caftans
caimans113811783caimans
callans94518473callans
cancans11311873cancans
captans111612053captans
carats85929023car_ats
caravans1338613caravans
carbarns1238563carbarns
carbons115418943carbons
carcass11310513carcass
cardons104519933cardons
careens94514703careens
carinas93622403carinas
carlins93921913carlins
carman103920743carman_
carns75937563car__ns
carpals113414623carpals
cartons94122473cartons
caymans14349513caymans
chazans21268123chazans
chazzans21234503chazzans
corbans11313173corbans
currans9310613currans
damans94715983da_mans
darbars10510093darbars
darkens12409873darkens
darns66927893dar__ns
darshans1286543darshans
durians839573durians
earlaps936393earlaps
earns55927563ear__ns
farads104713273far_ads
farfals13268503farfals
farinas103215233farinas
firmans12238523firmans
furans94515953fur_ans
garcons102411643garcons
gardant9314463gardant
gardens93312093gardens
garland948703garland
garlands1038323garlands
garrons82713463garrons
gazars164811553ga_zars
germans1079473germans
grans64832543_gr_ans
groans74815063_groans
hamzahs24134373hamzahs
hamzas20119013hamza_s
harass9313943har_ass
hardass1139753hardass
hardens113815023hardens
hardpans1436453hardpans
hariana10310243hariana
harianas1139163harianas
harijans1845723harijans
harkens144112863harkens
harmins123716723harmins
harpins123615703harpins
hartals10313023hartals
hazan173813613ha_zan_
hazzan17236803hazzan_
japans1539823ja_pans
jargons1558203jargons
jarinas143712183jarinas
jarrahs1735453jarrahs
jawans1657843ja_wans
jordans1566833jordans
kaftans14185353kaftans
kalians11310183kalians
kanbans1337723kanbans
karats106420493kar_ats
karmas123013733karma_s
karns96624143kar__ns
kurgans12145653kurgans
lagans75717783la_gans
lallans74113533lallans
lardons83914493lardons
lariats7615053lariats
larvas9310233larva_s
lauans65113533la_uans
lazars153812393la_zars
lorans65117603lor_ans
lurdans837073lurdans
magians10310753magians
mannans93611523mannans
maras75443293mar_a_s
margays1337493margays
margins103815193margins
marinas93519383marinas
markas124717003marka_s
marlins93420473marlins
maroons92615553maroons
marrams11310123marrams
marrano939423marrano
marranos1038423marranos
marrons93216973marrons
martens93714953martens
martians103111613martians
martins93322063martins
marzipans2242643marzipans
matzahs2134483matzahs
matzas1749703matza_s
mirzas1738183mirza_s
morgans10310123morgans
naans55815253na__ans
narwals1036983narwals
organs7912913_organs
paeans85118263pa_eans
paesans93312693paesans
pagans95717923pa_gans
paisans93614753paisans
parang93715513par_ang
parangs104314373par_angs
paras76143043par_a_s
parazoans2045603parazoans
pardahs13289673pardahs
pardons103817623pardons
pariahs123812343pariahs
parian83223963parian_
parkas125018023parka_s
parlays123910453parlays
parrals94414573parrals
parsons93516873parsons
partan83820563partan_
partizans2055243partizans
partons94620513partons
pavans115715593pa_vans
pyrans11411063pyr_ans
quartans1736283quartans
radians83013823radians
raglans82410133raglans
randans8313213randans
ratans63819373ra_tans
rattans73411953rattans
roans54926443__roans
sampans112411003sampans
saran53730303sar_an_
sardana838643sardana
sardanas937813sardanas
sardars83112903sardars
sarins63932623sar_ins
sarsars73512143sarsars
sarsens7311393sarsens
saurians837763saurians
stanzas1636363stanza_s
tablas83716163tabla_s
tabuns8489223ta_buns
tafias93111963tafia_s
taggant9310223taggant
taggants1044933taggants
tagrags936123tagrags
taigas73712563taiga_s
tailfans1144553tailfans
tains54936323ta__ins
taipan82410663taipan_
takas95520683ta_ka_s
takins105117403ta_kins
talars66021683ta_lars
talas55935893ta_la_s
talions7314113talions
talons64019443ta_lons
tamals84116633ta_mals
tambacs13219363tambacs
tambaks15218153tambaks
tameins9311413tameins
tampan102512323tampan_
tampons112711563tampons
tankas104613763tanka_s
tannins72813223tannins
tans46154823t___ans
tapas74627713ta_pa_s
tarama8412733tar_ama
taramas9612703taramas
tarantas839193tar_antas
tardies84225863tardies
tardyons1244613tardyons
tares57456563tar__es
targes74524593tar_ges
targets84314223targets
tariffs1334593tariffs
taring73932283tar_ing
tarlatans944353tarlatans
tarletans944653tarletans
tarmac10310333tarma_c
tarn46842723tar__n_
tarnal63716503tarna_l
tarocs84615663tar_ocs
taroks106115283tar_oks
taros55640823tar__os
tarots66422993tar_ots
tarpon82812803tarpon_
tarps76527113tar__ps
tarragons1044483tarragons
tarres64723043tar_res
tarries73324263tarries
tarring83318303tarring
tars46763953tar___s
tarsal63315273tarsa_l
tarsias74013373tarsias
tarsus6310513tar_sus
tartar63214753tarta_r
tartare73012683tartare
tarting84222653tarting
tarts57242023tar__ts
tatars64619793ta_tars
tauons63412673ta_uons
tautens7317843tautens
taverns10317803taverns
taxman15328613taxman_
taxons134211503ta_xons
tazza1338083tazza__
teargas837013tearga_s
teopans939203teopans
terais64023513ter_ais
terns55226873ter__ns
terrains8410323terrains
terrane72814233terrane
terranes82514433terranes
terras63516973terra_s
tertians839103tertians
therians1138313therians
thraws129211103thr_aws
threads11419953threads
threaps12488643threaps
threats104311673threats
throats104612193throats
tiaras6314553tiar_a_s
titans63414913t_itans
titians72710453titians
tolans64319273t_olans
tomans85419133t_omans
torahs95115643tor_ahs
toras55540373tor_a_s
tortas64918253torta_s
toucans937583toucans
trains64725343t_rains
trams75327673t_r_ams
trank96222423t_r_ank
tranks104017763t_r_anks
tranq145416893t_r_anq
tranqs155210313t_r_anqs
trapan82412973trapan_
traps75727483t_r_aps
trass56226473t_r_ass
trays85623433t_r_ays
treads74817923t_reads
treats64821693t_reats
treens65317873t_reens
trepans92311593trepans
triacs83913223t_riacs
triads74513533t_riads
trials64319883t_rials
triens65417543t_riens
troaks104410603t_roaks
tronas63816903t_ronas
truant6315783t_ruant
truants738163t_ruants
tsarinas835273tsarinas
turban8310483turban_
tureens7289873tureens
turions7311573turions
turnons737863turnons
turns55623233tur__ns
tympans14236813tympans
tyrant9315333tyr_ant
tyrants1037453tyr_ants
tzarinas1733973tzarinas
tzars144914273t__zars
varas86028193var_a_s
variant10316803variant
variants1139203variants
varias95019903varia_s
varnas94212823varna_s
wangans1149503wangans
wardens113711903wardens
warns87231003war__ns
warrant10614243warrant
warrants1168503warrants
warrens103810893warrens
warsaws1335763warsaws
yarns85621793yar__ns
zanzas1487053zanza_s
zazens1435833za_zens

Search took 7 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.390458182.1
2DLD Change Limit1340273475.95322514.2
3Display Results3473470.1232821.1
 (SQL Overall)1786913476.46627635.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.