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

238 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
karns9662414(None) 
barns76335141barns
carns75937561carns
darns66927891darns
earns55927561earns
kains96125641kains
kaons95014851kaons
karn86129411karn_
karts97630111karts
kerns94719561kerns
kirns95315451kirns
tarns56433951tarns
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
kaas86531842ka_as
kabs107130842ka_bs
kadis105921062kadis
kaes85734062ka_es
kafs116423742ka_fs
kagus105812032kagus
kaifs125715642kaifs
kails95525212kails
kain85334292kain_
kakas85117342kakas
kakis86116842kakis
kales95730982kales
kames115024692kames
kana85928522ka_na
kanas95326912kanas
kane85133962ka_ne
kanes95529372kanes
kaon87521022kaon_
kapas116021732kapas
kaphs144911502kaphs
karat96837592karat
karats106420492karats
karma113415002karma
karmas123013732karmas
karoo92519582karoo
karoos102415802karoos
kaross101910012kaross
karst97228992karst
karsts106012942karsts
kart86750802kar_t
kas77058582ka__s
katas95922092katas
kats85944332ka_ts
kauris103611522kauris
kavas125919952kavas
kayos127714702kayos
kays116032192ka_ys
kbars114612602kbar_s
keens95721182keens
kens85435232k_ens
kerbs115013672kerbs
kerfs125413572kerfs
kern85326212kern_
kerne94718212kerne
kernes104717522kernes
khans124615172khans
kilns95112982kilns
kins85747902k_ins
kirks84915262kirks
kirn87123432kirn_
kirs85831732kir_s
knars94416112knar_s
koans95818622koans
koras95927112koras
kors85933012kor_s
kris86423602k_ris
kurus98015632kurus
kyars124813962kyar_s
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572lar_s
lawns85215422lawns
learns65513742learns
mains75635092mains
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
tains54936322tains
tans46154812ta_ns
tares57456562tares
tarn46842722tarn_
taros55640822taros
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
terns55226872terns
trans54933042trans
turns55623232turns
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 5 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.186960704.3
2DLD Change Limit538002383.67314647.4
3Display Results2382380.1231935.0
 (SQL Overall)1786912383.98244874.7
 
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.