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

407 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
tarsals7251260(None) 
tarsal63315271tarsal_
argals75517712_argals
carpals113414622carpals
causals91411182causals
dorsals84110842dorsals
farfals13268502farfals
hartals10313022hartals
marsala939582marsala
marsalas1038252marsalas
marshals1337782marshals
narwals1036982narwals
nasals63312462na_sals
parrals94414572parrals
sarsars73512142sarsars
tahsils1035052tahsils
tamals84116632ta_mals
tarmacs1138322tarmacs
tarnal63716502tarnal_
tarpans92513532tarpans
tarsias74013372tarsias
tarsus6310512tars_us
tartans72615822tartans
tartars73313402tartars
tarzans16329922tarzans
tassels74510852tassels
trials64319882t_rials
vassals1057952vassals
warsaws1335762warsaws
aals49941143_a__als
aerials74017553aerials
annals66415923_annals
appals104812943_appals
araks94820883_ar_aks
areal55928733_areal_
areas55935773_area_s
argal65023393_argal_
argala74712673_argala
argalas84011093_argalas
argali75013753_argali
argalis84214193_argalis
argils75213623_argils
argols74514613_argols
arhats9312973_arhats
arias55438023_aria_s
ariels65119373_ariels
arils58732203_ar_ils
arousals866273_arousals
arras55626133_arra_s
arrays95311683_arrays
arsenals847733_arsenals
arses55733873_ars_es
arsis55722423_ars_is
arsons63917213_arsons
artal55525473_artal_
artels66216233_artels
arval86017013_arval_
aryls87015813_ar_yls
assails769093_assails
assais6711963_assais
assays977903_assays
atabals938413atabals
atrial65418943atrial_
baals76122703ba__als
balsams11579013balsams
balsas86417523balsa_s
barbal104016663barbal_
barbels114514433barbels
barcas101016603barca_s
barrels94514363barrels
basal75722283ba_sal_
basalt83519583ba_salt
basalts9358963ba_salts
basils85717473ba_sils
bharals1236733bhar_als
borals86721913bor_als
borstals1037463borstals
brasils9410973brasils
burials93612083burials
bursal84414823bursal_
bursars94510893bursars
bursas85318273bursa_s
cabals104020153ca_bals
caesars9410733caesars
canals84421663ca_nals
cantals93919573cantals
caracals12310753caracals
carats85929023car_ats
carcass11310513carcass
carcels114516063carcels
carfuls1249133carfuls
carls77037423car__ls
carnal83919203carnal_
carols85124983car_ols
carousals1165333carousals
carpal103716253carpal_
carpale113414353carpale
carpels115315463carpels
carrels95117303carrels
carses85233653cars_es
cartels94618123cartels
carvels124914593carvels
casas75327843ca_sa_s
casuals91410523casuals
causal81413203causal_
cereals9313173cereals
corals85325143cor_als
corrals93713853corrals
corsacs1139013corsacs
craals84113303_craals
curtals93111623curtals
damsels10126703damsels
darbars10510093darbars
darnels83710433darnels
darshans1286543darshans
dorsal74613943dorsal_
dorsels84412573dorsels
dossals8379293dossals
earfuls1036863earfuls
earlaps936393earlaps
earls56127513ear__ls
easels65914553ea_sels
eternals8238953eternals
facials123310743facials
fallals103310193fallals
farads104713273far_ads
fardels11389893fardels
farfal123410183farfal_
farfels13348213farfels
farls85731113far__ls
faucals12326563faucals
ferals94216643fer_als
formals123312893formals
gavials1136603gavials
gayals1039513ga_yals
gharials1245123gharials
gorals76917653gor_als
graals74112913_graals
halals95018313ha_lals
hamals114816823ha_mals
hammals14409223hammals
hansas94616043hansa_s
hansels104011653hansels
harass9313943har_ass
hardass1139753hardass
harls85634503har__ls
harshly1636273harshly
hartal9415473hartal_
hassels104311013hassels
hearsays1444513hearsays
herbals122710603herbals
hirsels10128343hirsels
jacals1539873ja_cals
jackals2036893jackals
jarfuls1754773jarfuls
jarls126120963jar__ls
jarrahs1735453jarrahs
karats106420493kar_ats
karmas123013733karma_s
karsts106012943kars_ts
kraals10378433_kraals
labials9299873labials
lariats7615053lariats
larval948503larval_
larvas9310233larva_s
mammals10389273mammals
manuals9311213manuals
maras75443293mar_a_s
marcels113212373marcels
margays1337493margays
markas124717003marka_s
marls75535163mar__ls
marrams11310123marrams
marses84827113mars_es
marshal1238973marshal_
marshall1345483marshall
marshalls1444833marshalls
marshes123615373marshes
marvels123810093marvels
masala8311813ma_sala
masalas9312053ma_salas
masas75630413ma_sa_s
massas85116463massa_s
matsahs1236563matsahs
missals93914423missals
morals85324633mor_als
morsels94112653morsels
mortals93914003mortals
murals84016763mur_als
narial6317953narial_
narwal938943narwal_
narwhals1443613narwhals
nasal56217593na_sal_
naysays1344123naysays
normals92510903normals
orals55826483_or_als
paesans93312693paesans
paisans93614753paisans
paisas84317493paisa_s
paras76143043par_a_s
parasails1147583parasails
parasols1039263parasols
parcels113712663parcels
pardahs13289673pardahs
pariahs123812343pariahs
parians93519733parians
parkas125018023parka_s
parlays123910453parlays
parols84722613par_ols
parral85517533parral_
parrels94713493parrels
parsable12311693parsable
parsecs11429923parsecs
parsers94118153parsers
parses85534703pars_es
parsons93516873parsons
partans94418283partans
partials101911953partials
pascals11610013pascals
passels93913023passels
pausal81511963pausal_
persalt9315413persalt
persalts1038193persalts
perusals1047143perusals
portals94015563portals
radials83614633radials
rascals959663rascals
ratals64219583ra_tals
reals55038653__reals
rials55026673__rials
sabals84618863sa_bals
sacrals93311793sacrals
salals65120083sa_lals
sals46851673___sals
salsas65316133salsa_s
sambals115213483sambals
sandals82715203sandals
sansars73313913sansars
sarans64224433sar_ans
sardars83112903sardars
sarsar63011843sarsa_r
sarsens7311393sarsens
serials73919743serials
servals103410743servals
sisals63013573_sisals
staysails1242853staysails
tablas83716163tabla_s
taels56822073ta__els
tafias93111963tafia_s
tagrags936123tagrags
tahsil936343tahsil_
taigas73712563taiga_s
tails55634193ta__ils
taipans9269553taipans
takas95520683ta_ka_s
talars66021683ta_lars
talas55935893ta_la_s
tallols73311363tallols
talls55133433ta__lls
tamal73522623ta_mal_
tamale83717403ta_male
tamales93216153ta_males
tambacs13219363tambacs
tambaks15218153tambaks
tambala1138023tambala
tambalas1237033tambalas
tampala1136613tampala
tampalas1245473tampalas
tampans113310983tampans
tankas104613763tanka_s
tansies74521243tansies
tantalus836373tantalus
tapalo839793ta_palo
tapalos938813ta_palos
tapas74627713ta_pa_s
tarama8412733tar_ama
taramas9612703taramas
tardies84225863tardies
tardily11269583tardily
tares57456563tar__es
targes74524593tar_ges
targets84314223targets
tariffs1334593tariffs
tarmac10310333tarma_c
tarnally1138273tarnally
tarns56433953tar__ns
tarocs84615663tar_ocs
taroks106115283tar_oks
taros55640823tar__os
tarots66422993tar_ots
tarpan82814293tarpa_n
tarpons92612213tarpons
tarps76527113tar__ps
tarres64723043tar_res
tarries73324263tarries
tars46763953tar___s
tarsi55222173tars__i
tarsia65514273tars_ia
tarsier74119253tarsier
tarsiers8298533tarsiers
tartan64217513tarta_n
tartana73010193tartana
tartanas8258893tartanas
tartar63214753tarta_r
tartare73012683tartare
tartily103511573tartily
tartly96014023tar_tly
tarts57242023tar__ts
tarzan152910753tarza_n
tasks94917583ta_s_ks
tass45640573ta_s__s
tassel66014773tassel_
tasses64826763ta_sses
tassets75012773tassets
tassies74918933tassies
tastes64126423ta_stes
tatars64619793ta_tars
tatsois748373tatsois
tawses94913193taws_es
taxols13328633ta_xols
tazzas1436283tazza_s
teals56234133t__eals
teargas837013tearga_s
teasels74311313teasels
tepals85415043t_epals
terais64023513ter_ais
tercels94110363tercels
tergal72912833tergal_
terras63516973terra_s
tersely1038113tersely
tertials8510073tertials
teslas64212173t_eslas
thermals13518533thermals
thrall93810293thr_all
thralls10299043thralls
thraws129211103thr_aws
threads11419953threads
threaps12488643threaps
threats104311673threats
thrills10398783thrills
throats104612193throats
tiaras6314553tiar_a_s
ticals83214713t_icals
timbals11239533timbals
tincals93610643tincals
tinsels738373tinsels
tirls54519803tir__ls
tonsils7310183tonsils
topsails1075093topsails
torahs95115643tor_ahs
toras55540373tor_a_s
torsade837593torsade
torsades937213torsades
torses64727953tors_es
torsks10549123tors_ks
torsos64815733tors_os
tortas64918253torta_s
torulas759853torulas
totals63115163t_otals
trails64622513t_rails
tramels93812493tramels
trams75327673t_r_ams
trans54933043t_r_ans
trapans92812463trapans
traps75727483t_r_aps
trashes104119263trashes
trass56226473t_r_ass
trasses74819323trasses
travails1146083travails
travels104711293travels
traversals1353253traversals
trawls94412393t_rawls
trays85623433t_r_ays
treads74817923t_reads
treats64821693t_reats
triacs83913223t_riacs
triads74513533t_riads
trial54926353t_rial_
tribals9610753tribals
trills64319853t_rills
triols66117803t_riols
troaks104410603t_roaks
trolls64613943t_rolls
trulls64110283t_rulls
trysails1144163trysails
tsars56717113t__sars
turbans939563turbans
tussahs10335113tussahs
tussal6288323tussal_
tussars7359253tussars
tymbals14265723tymbals
urials64415193_urials
vandals113211663vandals
varas86028193var_a_s
varias95019903varia_s
varnas94212823varna_s
vasal85516293va_sal_
vassal979243vassal_
verbals121910743verbals
versal93013753versal_
wadmals1335513wadmals
warsaw1236193warsa_w
warsle93112923wars_le
warsles103413643warsles
warstle10328013warstle
warstles11368803warstles
wassails1145953wassails

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.390458182.1
2DLD Change Limit1340274076.87619492.0
3Display Results4074070.1402907.1
 (SQL Overall)1786914077.40624127.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.