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

452 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
knaurs1046696(None) 
knars94416111kna_rs
knaur9508251knaur_
knurs94511151kn_urs
gaurs66317992_gaurs
gnarrs7407662gnarrs
gnars66718852gna_rs
incurs83012272incurs
kauri93811842k_auri
kauris103611522k_auris
kaury12429762k_aury
kbars114612602kba_rs
knacks11428542knacks
knaps115511172kna_ps
knar85818722kna_r_
knarry1334612knarry
knaves13439522knaves
knawes13328392knawes
knouts10438312knouts
knur85311972kn_ur_
knurl9398912kn_url
knurls10396242kn_urls
krauts10418512krauts
kyars124813962kya_rs
scaurs85512042scaurs
unaus53216572unau_s
acarus8312193acarus
afars85716513afa_rs
agars66120643aga_rs
airs46447423__airs
amours83512643amours
anabas8314083anabas
anas46649863ana__s
anears63717183anears
angers75222543angers
ankus91410683anku_s
annuls64711733annuls
anus47131113an_u_s
ars37670933__a_rs
augurs7399963augurs
auks85525263__auks
aura45836253__aura
auras55932553__auras
aures55137093__aures
auris55331523__auris
bars66564093_ba_rs
bauds85821043_bauds
bears75739043bea_rs
beaus75127113beau_s
beauts86015283beauts
blurs74619083_blurs
boars75229603boa_rs
burs65847423__burs
caners84629193caners
carrs75730853_carrs
cars67364763_ca_rs
cauls75727773_cauls
centaurs1035723centaurs
chairs114916173chairs
charrs115219183charrs
chars105936633cha_rs
clours85215083clours
concurs11311453concurs
curs65645543__curs
czars164812913cza_rs
daubs85014563_daubs
dauts67822243_dauts
deairs74013783deairs
dears65736883dea_rs
demurs939773demurs
denars74621433dena_rs
dinars75417563dina_rs
ears46356593_ea_rs
enacts84012973enacts
enamors939123enamors
enamours1044653enamours
enates64026423enates
enders74324053enders
endues73813903endues
endure74014143endure
endures83314603endures
enduro7338623enduro
enduros8298153enduros
ennuis636473ennuis
ensues63313813ensues
ensure63416003ensure
ensures73315903ensures
enters64425643enters
enure53520223en_ure
enures63919713en_ures
fairs85825443_fairs
fanums1137263fanums
fauns84516753_fauns
fears84829393fea_rs
femurs1136713femurs
feuars938653feuars
fiars86720833fia_rs
flairs95711913flairs
flours94414053flours
fours85521493_fours
frauds1036753frauds
furs76735043__furs
gars55750743_ga_rs
gauds75717723_gauds
gaums86217073_gaums
gaur56723353_gaur_
gauss65613453_gauss
gears64628693gea_rs
ghauts10447783ghauts
giaours834563giaours
glairs75211333glairs
gnar56021383gna_r_
gnarl65115573gna_rl
gnarls74210773gnarls
gnarr64810693gna_rr
gnats65217713gna_ts
gnawers11356383gnawers
gnaws96311143gna_ws
gnus56518003gn_u_s
guars65021043gua_rs
haars85620473_haars
hairs86225173_hairs
hauls86123733_hauls
hears86737373hea_rs
hoars85925543hoa_rs
honours10339353honours
hours85422383_hours
imaums10106303imaums
inanes62519803inanes
inarm7314423ina_rm
inarms8410093inarms
inburst937163inburst
incur72212253incur_
incus73315053incu_s
indues73515263indues
infers93615443infers
inhauls1035513inhauls
injure133410863injure
injures143111173injures
injury16266143injury
inkers104018833inkers
inners63919353inners
inpours936413inpours
inputs837703inputs
inruns6359513inruns
insure63416603insure
insures73117263insures
inters64328043inters
inturn63411563inturn
inturns73210133inturns
inure54119053in_ure
inures63318953in_ures
inurn53712863in_urn
inurns63310983in_urns
invars9310003invars
izars145112933iza_rs
jars117338353_ja_rs
jauks165412463_jauks
jaups144810533_jaups
jnanas13207303jnanas
kaas86531843k_a_as
kabars124513953kabars
kabs107130843k_a_bs
kadis105921063k_adis
kaes85734063k_a_es
kafirs13306983kafirs
kafs116423743k_a_fs
kagus105812033k_agus
kaifs125715643k_aifs
kails95525213k_ails
kains96125643k_ains
kakas85117343k_akas
kakis86116843k_akis
kales95730983k_ales
kames115024693k_ames
kanakas10327213kanakas
kanas95326913k_anas
kanes95529373k_anes
kanjis1735963kanjis
kantars11310033kantars
kanzus1944603kanzus
kaons95014853k_aons
kapas116021733k_apas
kaphs144911503k_aphs
karn86129413k_a_rn
karns96624143k_arns
karst97228993k_a_rst
kart86750803k_a_rt
karts97630113k_arts
kas77058583k_a__s
katas95922093k_atas
kats85944333k_a_ts
kauries113613193k_auries
kavas125919953k_avas
kayos127714703k_ayos
kays116032193k_a_ys
kbar106514653kba_r_
keas86337093kea__s
kebars124112493kebars
kefirs13396653kefirs
keirs95313673k_eirs
kenafs1337113kena_fs
khadis1446913khadis
khafs15648843kha_fs
khakis1265853khakis
khans124615173kha_ns
khaphs18394323khaphs
khats125316013kha_ts
khoums1594013khoums
kiangs11378363kiangs
kiaugh1442813kiaugh
kiaughs1542283kiaughs
kiers95320093k_iers
kinara10310363kina_ra
kinaras1159093kinaras
kinas95626913kina__s
kinases113511123kinases
kirs85831733k__irs
kiters105218583kiters
knack104311043kna_ck
knackers13286843knackers
knap105815403kna__p
knappers16315643knappers
knarred12266003knarred
knave12389463kna_ve
knavery1733123knavery
knavish1743993knavish
knawe12397883kna_we
knawel13415413knawel
knawels14344683knawels
kneaders1384713kneaders
kneads11357093kneads
kneels10408933kneels
knees95114873kn_ees
knells10439253knells
knifers14537083knifers
knifes136210213knifes
knits93914743kn_its
knives13458553knives
knobs11519713kn_obs
knocks11397443knocks
knolls10367413knolls
knops115911813kn_ops
knosps12405013knosps
knots95614723kn_ots
knout95018263knou_t
knowers1436333knowers
knowns13426443knowns
knows124912413kn_ows
knurly13405533kn_urly
koalas104011663koalas
koans95818623koa_ns
koas85635093koa__s
kors85933013k__ors
kouros1039183k_ouros
kraals10378433kraals
krafts13438853krafts
kraits104912203kraits
kraters114212333kraters
kraut95221403krau_t
kudus104910803kudu_s
kues86426773k__ues
kulturs1134723kulturs
kuru85521803k__uru
kurus98015633k__urus
kvas117015943kva__s
kvases13467103kvases
kvass12507273kva_ss
kyacks14416063kyacks
kyaks11459163kya_ks
kyar116916843kya_r_
kyats125012443kya_ts
lairs55425873_lairs
langurs889103langurs
lars46956573_la_rs
lauds65618483_lauds
laura54116203_laura
lauras63414333_lauras
lears55938733lea_rs
lemurs837253lemurs
liars54723163lia_rs
lours55125293_lours
luaus54514903luau_s
lunars65012813luna_rs
maars74621633_maars
mairs76228303_mairs
manors84420883manors
manure8313653manure
manures9313353manures
manus75924923manu_s
mars66261863_ma_rs
mauds85519273_mauds
mauls76524953_mauls
mauts75927193_mauts
miauls8178713miauls
mohurs1135933mohurs
naans55815253_naans
nabes75427093_nabes
nabis76020583_nabis
nabs66236193_na_bs
nacre75715363_nacre
nacres85614453_nacres
nadas66320813_nadas
nadirs7109003_nadirs
naffs116213963_naffs
nags55436023_na_gs
naifs87617423_naifs
nails55730403_nails
naira5314743_naira
nairas6312773_nairas
nairu5413813_nairu
nairus639143_nairus
nalas55528363_nalas
namers84517333_namers
names74833363_names
nanas55928633_nanas
nans46139393_na_ns
naos47429733_na_os
napas75924353_napas
napes74828463_napes
naps66238583_na_ps
narc67127953_na_rc
narcs76122023_narcs
nard56634453_na_rd
nards65928463_nards
nares55544153_nares
naris55735293_naris
nark85230063_na_rk
narks96026033_narks
nary76931223_na_ry
nates55238333_nates
nature6311263_nature
natures7311963_natures
navars92810573_navars
naves87030383_naves
nays75931593_na_ys
nazis145216083_nazis
nears55529423_nears
neuks96510863_neuks
neums75414253_neums
noirs55615463_noirs
nouns56717313_nouns
nous46136983_nou_s
nubs65927143_n_ubs
nuns45228233_n_uns
nurd56224343_n_urd
nurds65518523_n_urds
nurl45327243_n_url
nurls55519683_n_urls
nurse54420123_n_urse
nus37939393_n_u_s
nuts45032673_n_uts
oars46846033_oa_rs
occurs10136553occurs
odours7418233odours
onagers838103onagers
onagri754963onagri
onus45826813on_u_s
ours47237563__ours
pairs75325833_pairs
parrs75928673_parrs
pars67560793_pa_rs
pears75138613pea_rs
pours74623183_pours
praus74621753prau_s
purs65641043__purs
rears54739653rea_rs
recurs83315803recurs
roars55622233roa_rs
santurs7310763santurs
sauls55128123_sauls
saury84317223_saury
scars75433533sca_rs
scaups105411933scaups
scaur75814903scaur_
scours84913583scours
sears54744913sea_rs
shauls94913113shauls
sieurs659043sieurs
slurs54123373_slurs
snacks124514553snacks
snafus936743snafus
snags64421313sna_gs
snails64816653snails
snakes103919603snakes
snaps74719563sna_ps
snare54429983sna_re
snarers74216663snarers
snares65329033snares
snarf86525423sna_rf
snarfs95113423snarfs
snark95419943sna_rk
snarks104815733snarks
snarl54921083sna_rl
snarls64016873snarls
snaths95112913snaths
snaws86116363sna_ws
sneers64016173sneers
snouts64915863snouts
snubs75412553sn_ubs
snugs64913023sn_ugs
soars54732513soa_rs
sonars64818973sona_rs
sours55230503_sours
spars75431543spa_rs
spurs74621523_spurs
stairs65416333stairs
stars55836573sta_rs
stours65015623stours
tahrs85412333_tahrs
tars46763953_ta_rs
taus46342733_tau_s
tauts56125513_tauts
tears55436463tea_rs
tenours72610053tenours
tours55325863_tours
tsars56717103tsa_rs
tzars144914273tza_rs
unais53420773una_is
unarm7314453una_rm
unarms839243unarms
unary8315993una_ry
unau43924153unau__
unbars82113033unbars
uncurb1037043uncurb
uncurbs1134913uncurbs
uncurl839413uncurl
uncurls937123uncurls
uncus74014983uncu_s
unfurl937953unfurl
unfurls1035573unfurls
ungues7412123ungues
unguis738453unguis
unhairs1036373unhairs
unhurt9311253unhurt
unpure82911533unpure
unsure62815413unsure
vairs85019133_vairs
vars75742073_va_rs
varus85921183_varus
vaus75928923_vau_s
wairs86424063_wairs
wars78659803_wa_rs
wauks125515163_wauks
wauls86120553_wauls
waur76819903_waur_
wears86030303wea_rs
whaups14405753whaups
yauds95013223_yauds
yaups105910743_yaups
years84527673yea_rs
yours85217873_yours

Search took 10 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127164528.75012881.8
3Display Results4524520.3131444.1
 (SQL Overall)1786914529.20619410.3
 
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.