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

325 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
tarns5643395(None) 
barns76335141barns
carns75937561carns
darns66927891darns
earns55927561earns
karns96624141karns
tains54936321tains
tans46154811ta_ns
tares57456561tares
tarn46842721tarn_
taros55640821taros
tarps76527111tarps
tars46763951tar_s
tarts57242021tarts
terns55226871terns
trans54933041trans
turns55623231turns
warns87231001warns
yarns85621791yarns
ains46158882_ains
airns55521032airns
arbs66834732_arbs
arcs67834782_arcs
ares45871022_ares
arfs76029962_arfs
arks85936872_arks
arms66137492_arms
ars37670932_ar_s
arts49650262_arts
awns75324432_awns
bairns86710872bairns
banns75321232banns
bans66555132ba_ns
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barn66444642barn_
barny105821732barny
barons85025382barons
bars66564092bar_s
brans75437432brans
burns74926772burns
cains75334302cains
cairns85313302cairns
cans65050842ca_ns
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carls77037422carls
carn66245432carn_
carny105822922carny
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
corns76034762corns
curns74924272curns
damns84916922damns
dans56748142da_ns
darbs85323262darbs
dares66146702dares
darks106727872darks
darn56434622darn_
darts67635732darts
dawns95916592dawns
durns64819862durns
earls56127512earls
earn46737552earn_
ears46356592ear_s
erns45428222_erns
fans76247362fa_ns
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
fauns84516752fauns
fawns115914262fawns
ferns85220082ferns
firns86018542firns
gains65729512gains
garbs86321412garbs
garni6315702garni
gars55750742gar_s
girns64516802girns
grans64832542grans
hards96435652hards
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926862harps
harts88441592harts
herns84825582herns
horns86125332horns
jarls126120962jarls
jars117338352jar_s
kains96125642kains
kaons95014852kaons
karn86129412karn_
karts97630112karts
kerns94719562kerns
kirns95315452kirns
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572lar_s
lawns85215422lawns
learns65513742learns
mains75635102mains
mans66354532ma_ns
maras75443282maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marls75535162marls
mars66261862mar_s
marts77442232marts
morns75527442morns
naans55815252naans
nans46139392na_ns
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
oars46846032oar_s
pains75138282pains
pans65855722pa_ns
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792par_s
parts77743372parts
pawns108818132pawns
pirns76020092pirns
porns75527342porns
rains55140232rains
rares55247442rares
sains55639972sains
sans45153352sa_ns
sarans64224432sarans
sards64736182sards
sarins63932622sarins
saris54544952saris
sarks96632462sarks
saros55238062saros
sharns95516982sharns
sorns55028412sorns
stains64923652stains
stares66038752stares
stars55836572star_s
starts65423122starts
sterns64616752sterns
tabes76033922tabes
tabs66842982ta_bs
tabuns8489222tabuns
tabus74820922tabus
taces76237802taces
tachs105820932tachs
tacks115430132tacks
tacos77023552tacos
tacts76524122tacts
tads57143942ta_ds
taels56822072taels
tags55545232ta_gs
tahrs85412332tahrs
tails55634192tails
tain45548072tain_
taint55542282taint
taints64520532taints
tajes124920692tajes
takas95520682takas
takes94437792takes
takins105117402takins
talas55935892talas
talcs74817182talcs
tales55451372tales
talks94322692talks
talls55133432talls
talons64019422talons
talus55423262talus
tames75242012tames
tamis76728722tamis
tamps95524082tamps
tams67247932ta_ms
tan37167562ta_n_
tang56138662ta_ng
tangs65028342tangs
tank85134012ta_nk
tanks94624732tanks
tansy84514932ta_nsy
taos45541002ta_os
tapas74627712tapas
tapes75838602tapes
tapis75028862tapis
taps66050672ta_ps
tar37570692tar__
tardo65321102tardo
tardy94720462tardy
tare45957622tar_e
tared69340052tared
targe65227092targe
targes74524592targes
taring73932282taring
tarnal63716502tarnal
tarnish101611872tarnish
taro46846912tar_o
taroc75721642taroc
tarocs84615662tarocs
tarok97921072tarok
taroks106115282taroks
tarot55943932tarot
tarots66422992tarots
tarp66936412tar_p
tarpans92513532tarpans
tarpons92612202tarpons
tarre55825632tarre
tarres64723042tarres
tarry85422512tarry
tarsi55222172tarsi
tarsus6310512tarsus
tart47566182tar_t
tartans72615822tartans
tarty86328182tarty
tarzans16329922tarzans
tas38477102ta__s
tasks94917582tasks
tass45640572ta_ss
tates55444982tates
tats46858132ta_ts
taunt55532282taunt
taunts65715662taunts
tauons63412672tauons
taus46342732ta_us
tauts56125512tauts
taverns10317802taverns
tavs75630972ta_vs
tawny114713652tawny
taws75641592ta_ws
taxes124730822taxes
taxis126821972taxis
taxons134211502taxons
taxus125512482taxus
tears55436462tear_s
teens56227482teens
tens45647412t_ens
terms75523472terms
tern46134802tern_
terne56426152terne
ternes65422902ternes
tharms115712242tharms
thens85921832thens
thins85826322thins
thorns95314092thorns
tiaras6314532tiaras
tins45251302t_ins
tires55437492tires
tirls54519802tirls
tiros54524892tiros
tons46553052t_ons
toons55027532toons
toras55540372toras
torcs75123762torcs
tores55352672tores
torn46044252torn_
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torts56138122torts
torus54329762torus
towns86018882towns
trains64725342trains
trams75327672trams
trank96222422trank
tranks104017762tranks
tranq145416892tranq
tranqs155210312tranqs
traps75727482traps
trass56226472trass
trays85623432trays
tres46542902t_res
tsars56717102tsar_s
tuns45138662t_uns
turds65021692turds
turfs84620442turfs
turks95320822turks
turn46330382turn_
turps74918732turps
twains95811182twains
twins85118982twins
tyres84725232tyres
tyros85118592tyros
tzars144914272tzar_s
urns46323892_urns
vans76236722va_ns
varas86028192varas
varna84516172varna
varnas94212822varnas
vars75742072var_s
varus85921182varus
wains86930862wains
wans76452262wa_ns
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warn75239322warn_
warps107126422warps
wars78659802war_s
warts814840402warts
yards95324612yards
yarn75230042yarn_
yawns114213272yawns
yearns9509542yearns
zarfs174713622zarfs

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 Limit538003251.65632487.9
3Display Results3253250.0933494.6
 (SQL Overall)1786913251.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.