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 “taros” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

322 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
taros5564082(None) 
faros85532021faros
saros55238061saros
tacos77023551tacos
taos45541001ta_os
tares57456561tares
tarns56433951tarns
taro46846911taro_
taroc75721641taroc
tarocs84615661tarocs
tarok97921071tarok
taroks106115281taroks
tarot55943931tarot
tarots66422991tarots
tarps76527111tarps
tars46763951tar_s
tarts57242021tarts
tiros54524891tiros
toros54336191toros
tyros85118591tyros
abos67734412_abos
ados57633512_ados
apos65433822_apos
arbs66834732_arbs
arcs67834782_arcs
ares45871022_ares
arfs76029962_arfs
arks85936872_arks
arms66137492_arms
arose55832082_arose
ars37670932_ar_s
arts49650262_arts
arvos86015662_arvos
avos77227012_avos
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
baron78131242baron
barons85025382barons
bars66564092bar_s
biros75325132biros
bros65635662_bros
calos74431902calos
camos95927612camos
capos94826072capos
carbos105122262carbos
carbs96031462carbs
cards85137932cards
cares77369182cares
cargos94619182cargos
carks115534212carks
carls77037422carls
carns75937562carns
carob95325222carob
carobs104818102carobs
carol75128612carol
carols85124982carols
carom95025562carom
caroms105619572caroms
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
ceros74726072ceros
claros84015112claros
dados75522432dados
dagos76419442dagos
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
datos65222782datos
duros65422692duros
earls56127512earls
earns55927562earns
ears46356592ear_s
eros45238452_eros
euros54920242euros
fados95620732fados
fanos85926502fanos
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faro76136922faro_
farts88336842farts
garbs86321412garbs
gars55750742gar_s
giros65722652giros
gyros95616482gyros
halos85230252halos
hards96435652hards
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926862harps
harts88441592harts
heros84930862heros
jarls126120962jarls
jars117338352jar_s
jatos125116822jatos
karns96624142karns
karoo92519582karoo
karoos102415802karoos
kaross101910012kaross
karts97630112karts
kayos127714702kayos
lards65331862lards
lares54852632lares
largos74815062largos
laris54737462laris
larks95227812larks
lars46956572lar_s
macros104017012macros
makos116518362makos
manos74933612manos
maras75443282maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marls75535162marls
mars66261862mar_s
marts77442232marts
mayos105521932mayos
naos47429732na_os
narcos86714202narcos
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
oars46846032oar_s
paras76143042paras
pards85634332pards
pareos87023772pareos
pares77164482pares
pargos95719042pargos
paris75145942paris
parks116134462parks
parol74826272parol
parols84722612parols
parous84024162parous
parrs75928672parrs
pars67560792par_s
parts77743372parts
parvos116614752parvos
pharos11312062pharos
praos74923562praos
pros65742782_pros
pyros105718292pyros
rares55247442rares
ratos55528762ratos
sagos66123872sagos
sards64736182sards
sargos74318272sargos
saris54544952saris
sarks96632462sarks
sarod65325872sarod
sarods74918572sarods
stares66038752stares
stars55836572star_s
starts65423122starts
tabes76033922tabes
taboo73418092taboo
taboos83815422taboos
tabor75518392tabor
tabors84517092tabors
tabs66842982ta_bs
tabus74820922tabus
taces76237802taces
tachs105820932tachs
tacks115430132tacks
taco67031352taco_
tacts76524122tacts
tads57143942ta_ds
taels56822072taels
tags55545232ta_gs
tahrs85412332tahrs
tails55634192tails
tains54936322tains
tajes124920692tajes
takas95520682takas
takes94437792takes
talas55935892talas
talcs74817182talcs
tales55451372tales
talks94322692talks
talls55133432talls
talon55824112talon
talons64019422talons
talus55423262talus
tames75242012tames
tamis76728722tamis
tamps95524082tamps
tams67247932ta_ms
tangos74216302tangos
tangs65028342tangs
tanks94624732tanks
tans46154812ta_ns
tao38358952ta_o_
tapas74627712tapas
tapes75838602tapes
tapis75028862tapis
taps66050672ta_ps
tar37570692tar__
tardo65321102tardo
tardy94720462tardy
tare45957622tar_e
tared69340052tared
targe65227092targe
targes74524592targes
tarn46842722tar_n
tarp66936412tar_p
tarpon82812802tarpon
tarpons92612202tarpons
tarre55825632tarre
tarres64723042tarres
tarry85422512tarry
tarsi55222172tarsi
tarsus6310512tarsus
tart47566182tar_t
tarty86328182tarty
tas38477102ta__s
tasks94917582tasks
tass45640572ta_ss
tates55444982tates
tats46858132ta_ts
tauon54816582tauon
tauons63412672tauons
taus46342732ta_us
tauts56125512tauts
tavs75630972ta_vs
taws75641592ta_ws
taxes124730822taxes
taxis126821972taxis
taxol124011362taxol
taxols13328632taxols
taxon124414662taxon
taxons134211502taxons
taxus125512482taxus
tears55436462tear_s
telos55424522telos
terms75523472terms
terns55226872terns
tharms115712242tharms
thro77726422thro_
throb109816852throb
throbs118311372throbs
throe89321422throe
throes97518672throes
throw118719732throw
throws129715232throws
tiaras6314532tiaras
tires55437492tires
tirls54519802tirls
tiro46832362tiro_
topos75726392topos
toras55540372toras
torcs75123762torcs
tores55352672tores
toro48045682toro_
torose64317692torose
torot56139942torot
torous64319022torous
torrs53923562torrs
tors46157382tor_s
torso56922142torso
torsos64815732torsos
torts56138122torts
torus54329762torus
toyos87519142toyos
trams75327672trams
trans54933042trans
traps75727482traps
trass56226472trass
trays85623432trays
tres46542902t_res
trios55528092trios
trod57627952t_rod
trog57628212t_rog
trogs67022602t_rogs
trois57226092t_rois
trop66833302t_rop
trot46351312t_rot
trots56629942t_rots
trow78031422t_row
trows88826182t_rows
troy77429682t_roy
troys86418612t_roys
tsars56717102tsar_s
turbos8910782turbos
turds65021692turds
turfs84620442turfs
turks95320822turks
turns55623232turns
turps74918732turps
twos76718022t_wos
typos106015812typos
tyres84725232tyres
tyro76622362tyro_
tzars144914272tzar_s
varas86028192varas
vars75742072var_s
varus85921182varus
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802war_s
warts814840402warts
yards95324612yards
yarns85621792yarns
zarfs174713622zarfs
zeros144918102zeros

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538003221.65632487.9
3Display Results3223220.0933462.4
 (SQL Overall)1786913221.84297009.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.