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

414 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
tarsias7401337(None) 
tarsia65514271tarsia_
arias55438022_ar_ias
arsis55722422_arsi_s
atresias839472atresias
cardias10715112cardias
cassias93514342cassias
intarsias945922intarsias
taenias7311282taenias
taffias13377412taffias
tafias93111962ta_fias
tahsils1035052tahsils
tansies74521242tansies
taramas9612702taramas
tardies84225862tardies
tarries73324262tarries
tarsal63315272tars_al
tarsals72512602tarsals
tarsi55222172tarsi__
tarsier74119252tarsier
tarsiers8298532tarsiers
tarsus6310512tars_us
tassies74918932tassies
terbias9310742terbias
varias95019902var_ias
abasias9711013abasias
abrosias1049033abrosias
acrasias1048893acrasias
agrias74315393_agrias
alias55834603_a_lias
amias75831473_a_mias
amusias938583amusias
apsis75718293_apsi_s
areas55935773_ar_eas
arecas84817443_arecas
arenas65021993_arenas
arepas85515703_arepas
argils75213623_argils
aria46245423_ar_ia_
arils58732203_ar_ils
arises65233803_arises
aristas7413523_aristas
armies85123693_armies
arnicas939543_arnicas
aroids75118223_aroids
aromas81018613_aromas
arras55626133_ar_ras
arris56824683_arri_s
arses55733873_ars_es
arshins10312573_arshins
arsine64021043_arsine
arsines73518813_arsines
arsino64113513_arsino
arsons63917213_arsons
assais6711963_assais
astasias8410143asta_sias
ataraxias1644313ataraxias
ataxias14189343ataxias
atonias73315993atonias
atresia7310223atresia_
atria56022343atr_ia_
atrial65418943atr_ial
babesias1246113babesias
balsas86417523bals_as
banksias1445893banksias
barbies114519593barbies
barcas101016603bar_cas
baristas1039723baristas
barrios9310773barrios
barytas12378283barytas
basics104915123ba_sics
basils85717473ba_sils
basins85722763ba_sins
basis75429863ba_si_s
brasils9410973brasils
bursas85318273burs_as
camisas113411923camisas
camisias12268603camisias
capias10318353ca_pias
capsids1239333capsids
cardia9916373cardia_
cardiac1278813cardiac
cardiacs1376913cardiacs
cardiae10713703cardiae
caries85147623car_ies
carinas93622403carinas
caritas93316953caritas
carlins93921913carlins
carnies94123963carnies
carries94328013carries
carses85233653cars_es
carsick1536343carsick
casas75327843ca_s_as
casitas93312043ca_sitas
cassia83714763cassia_
cassinas103610633cassinas
cassis84818853cassi_s
cerias83321983cer_ias
clarkias1444793clarkias
crasis85020473crasi_s
dahlias1135723dahlias
daisies84217093daisies
darbies104216983darbies
darics94314113dar_ics
darkies124015753darkies
darshan1167063darshan
darshans1286543darshans
dassies84418663dassies
earwigs11104413earwigs
easies64126633ea_sies
entasias8269143enta_sias
facias113415803fa_cias
falsies103515013falsies
farcies125317883farcies
farinas103215233farinas
farside1138603farside
farsides1237993farsides
fascias1258413fascias
ferias95020393fer_ias
gambias125010733gambias
garlics1038013garlics
giardias1045023giardias
hansas94616043hans_as
hardies114923233hardies
harissa1035503harissa
harissas1145983harissas
harmins123716723harmins
harpies123818313harpies
harpins123615703harpins
harries103525493harries
hernias10310773hernias
intarsia845763intarsia_
jarinas143712183jarinas
jassids1586143jassids
kalmias1347973kalmias
kamsins1346963kamsins
karmas123013733kar_mas
karsts106012943kars_ts
kashas133311903ka_shas
kerrias11289513kerrias
lamias85020613la_mias
lariat6629043lar_iat
lariats7615053lar_iats
laris54737463lar_i_s
larvas9310233lar_vas
lassies74420103lassies
lassis65216703lassi_s
latrias71913213latrias
maffias15327283maffias
mafias113913573ma_fias
manias84029033ma_nias
maracas11313773maracas
maras75443283mar__as
marascas1247383marascas
margins103815193margins
maria75032883mar_ia_
marinas93519383marinas
markas124717003mar_kas
markkas12356083markkas
marlins93420473marlins
marries93825283marries
marsalas1038253marsalas
marses84827113mars_es
marshal1238973marshal
marshals1337783marshals
marshes123615373marshes
martial92415413martial
martian93514683martian
martians103111613martians
martins93322063martins
masas75630413ma_s_as
massas85116463ma_ssas
massifs1237743massifs
narial6317953nar_ial
naris55735293nar_i_s
nasial6413283na_sial
nauseas735993nauseas
norias65518203nor_ias
oarsman937733oarsman
oasis56422553oa_si_s
otalgias944183otalgias
paisas84317493pais_as
palsies94420273palsies
pansies94521983pansies
paras76143043par__as
pareiras1038183pareiras
paresis93315093paresi_s
pariah114320583par_iah
pariahs123812343par_iahs
parian83223963par_ian
parians93519733par_ians
paries84742513par_ies
paris75145943par_i_s
parises94827183parises
parkas125018023par_kas
parosmias1345783parosmias
parries93925843parries
parsecs11429923parsecs
parsers94118153parsers
parses85534703pars_es
parsing103819553parsing
parsnips1245533parsnips
parsons93516873parsons
partial92616263partial
partials101911953partials
parties93230863parties
partitas10310253partitas
paruras9310533paruras
parvis116114803parvi_s
pashas115117063pa_shas
pastas85422873pa_stas
patsies93919483patsies
quassias1754933quassias
raffias13237713raffias
raias54631123__raias
raisins72715343raisins
raphias123511083raphias
rias45540593__r_ias
salsas65316133sals_as
salvias10279933salvias
sarcinas1039273sarcinas
sardius839553sardius
sarins63932623sar_ins
saris54544953sar_i_s
sarsar63011843sars_ar
sarsars73512143sarsars
sarsens7311393sarsens
sasins64923103sa_sins
sassies74719263sassies
sharias102516003shar_ias
stadias8411113sta_dias
starships1447663starships
stasis63116873sta_si_s
tabbies112913503tabbies
tabbis102910863tabbi_s
tablas83716163ta_blas
tactics1149323tactics
taenia6313193taenia_
taeniae739083taeniae
taffia12286903taffia_
taffies133012693taffies
tafia84215493ta_fia_
tahsil936343tahsi_l
taigas73712563ta_igas
tails55634193ta__ils
tains54936323ta__ins
takas95520683ta__kas
takins105117403ta_kins
talas55935893ta__las
talkies113415733talkies
tallies73624603tallies
tallis63319963talli_s
tallits73215993tallits
talukas11316213talukas
tamashas13135683tamashas
tameins9311413tameins
tamis76728733ta_mi_s
tamises92715973tamises
tammies113814683tammies
tanists7313653tanists
tankas104613763ta_nkas
tannins72813223tannins
tantras73112093tantras
tapas74627713ta__pas
tapirs84113173ta_pirs
tapis75028863ta_pi_s
tapises92914013tapises
tarama8412733tarama_
tarantas839193tarantas
tardier859719993tardier
tardiest93515243tardiest
tardily11269583tardily
tardive1136893tardive
tares57456563tar__es
targes74524593tar_ges
targets84314223targets
tariff12711363tar_iff
tariffs1334593tariffs
taring73932283tar_ing
tarmac10310333tar_mac
tarmacs1138323tarmacs
tarnal63716503tar_nal
tarnish101611873tarnish
tarns56433953tar__ns
tarocs84615663tar_ocs
taroks106115283tar_oks
taros55640823tar__os
tarots66422993tar_ots
tarpan82814293tar_pan
tarpans92513533tarpans
tarpons92612203tarpons
tarps76527113tar__ps
tarres64723043tar_res
tarried83914133tarried
tarrier74323173tarrier
tarriers83411713tarriers
tarriest83215003tarriest
tarring83318303tarring
tars46763953tar___s
tartan64217513tar_tan
tartanas8258893tartanas
tartans72615823tartans
tartar63214753tar_tar
tartars73313403tartars
tartier74123263tartier
tartiest82718313tartiest
tartily103511573tartily
tarting84222653tarting
tartish101512633tartish
tarts57242023tar__ts
tarzan152910753tar_zan
tarzans16329923tarzans
tasks94917583ta_s_ks
tass45640573ta_s__s
tassels74510853tassels
tasses64826763ta_sses
tassets75012773tassets
tassie66017023tassi_e
tastes64126423ta_stes
tatsois748373tatsois
tatties74120343tatties
tawnies102812503tawnies
tawpies12309873tawpies
tawses94913193taws_es
tawsing1138673tawsing
taxies135817333ta_xies
taxis126821973ta_xi_s
tazzas1436283ta_zzas
teargas837013tear_gas
tenias64720073t_enias
terais64023513terai_s
terbia8311153terbia_
terras63516973ter_ras
terries73425633terries
territs72714503territs
tertial7313863tertial
tertials8510073tertials
tertian7511193tertian
tertians839103tertians
teslas64212173t_eslas
thesis94913733thesi_s
thorias102312053thorias
thrips11299013thr_ips
thulias1035743thulias
tiaras6314553tiar__as
tibias839953t_ibias
tmesis8529793tmesi_s
tocsins939963tocsins
tonsils7310183tonsils
toras55540373tor__as
torics85118353tor_ics
tories65435883tor_ies
toroids8310643toroids
torpids1037373torpids
torses64727953tors_es
torsi57423363torsi__
torsion7310803torsion
torsions839183torsions
torsks10549123tors_ks
torsos64815733tors_os
tortas64918253tor_tas
torulas759853torulas
tragics10338083tragics
traiks104013713t_raiks
trails64622513t_rails
trains64725343t_rains
traits65121983t_raits
transits8313503transits
trashes104119263trashes
trass56226473tras__s
trasses74819323trasses
traumas938593traumas
triac74116373t_r_iac
triacs83913223t_r_iacs
triad65217723t_r_iad
triads74513533t_r_iads
trial54926353t_r_ial
trials64319883t_r_ials
tries55742813t_r_ies
trigs65423063t_r_igs
trims75021473t_r_ims
trios55528093t_r_ios
trips74923363t_r_ips
troikas1135033t_roikas
trois57226093t_roi_s
tronas63816903t_ronas
tsarinas835273tsarinas
tsarisms1056653tsarisms
tsarists857303tsarists
turbits969233turbits
turistas846693turistas
turnips935013turnips
tussis6379953tussi_s
tzarinas1733973tzarinas
tzarisms1965213tzarisms
tzarists1755693tzarists
uranias72113813uranias
urbias839093_urbias
ursids737823_ursids
varas86028193var__as
varia85824203var_ia_
varies94330873var_ies
varnas94212823var_nas
varsity1356673varsity
warsaw1236193wars_aw
warsaws1335763warsaws
warships1647553warships
warsles103413643warsles
yautias1046333yautias
yttrias1044523yttr_ias
zamias174212923za_mias
zarebas1836303zarebas
zaribas1836043zaribas
zoysias1943843zoysias

Search took 9 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.1561145455.1
2DLD Change Limit1340274147.82617125.9
3Display Results4144140.1602587.5
 (SQL Overall)1786914148.14221946.8
 
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.