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

307 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
knosps1240501(None) 
knops115911811kno_ps
knosp11576821knosp_
enosis63816422enosis
gnoses76515162gnoses
gnosis75711212gnosis
kenosis11369002kenosis
kiosks934382kiosks
knaps115511172kn_aps
knobs11519712kno_bs
knocks11397442knocks
knolls10367412knolls
knop107116592kno_p_
knots95614722kno_ts
knouts10438312knouts
knowns13426442knowns
knows124912412kno_ws
kops107031292k_o_ps
koss85224812k_os_s
noses55435642_noses
snoops84314162snoops
angsts738863angsts
anises64826693anises
anoas57226493ano_as
anodes74418753anodes
anoles64827423anoles
anuses66218773anuses
asps65622093__asps
bloops106611343bloops
boosts86115013boosts
bops86037983_bo_ps
bosks115218853_bosks
boss65938343_bos_s
broses86524403broses
chomps155112223chomps
chops125019873cho_ps
choses115825123choses
clasps104512093clasps
clomps125212233clomps
clops95924853clo_ps
closes85425593closes
comps115526053_comps
coops96229643_coops
cops86751373_co_ps
corps95927043_corps
coses76949493_coses
coss66143493_cos_s
costs77231143_costs
coups95522473_coups
crisps104411513crisps
crops96125233cro_ps
cross75124503cros_s
croups104312553croups
cusps94913673_cusps
dorps85419223_dorps
doses65938503_doses
doss56235043_dos_s
droops95110963droops
drops85719503dro_ps
dross65418093dros_s
enokis103010273enokis
enols54718403eno_ls
enows85115493eno_ws
eposes84418783eposes
eroses65327053eroses
flops105920143flo_ps
floss85118263flos_s
fops96532683_fo_ps
foss76431643_fos_s
frosts94214623frosts
gasps85415483_gasps
ghosts10489273ghosts
glops85619553glo_ps
gloss64319623glos_s
glosts74513813glosts
gnomes93812973gnomes
goops86620963_goops
gooses75723053gooses
gorps85316993_gorps
grasps9489253grasps
gross65421693gros_s
groups94210513groups
hasps105114643_hasps
hoops105621073_hoops
hops97942633_ho_ps
hoses85443173_hoses
hosts85526703_hosts
joss115925593_jos_s
kaons95014853kao_ns
kaross101910013karos_s
karsts106012943karsts
keeps116020283k_eeps
keleps12478813keleps
kelps115116423k_elps
kemps135012523k_emps
kenos95220623keno__s
keps106027303k__eps
ketoses114912873ketoses
ketosis11429733ketosis
khoums1594013khoums
kinases113511123kinases
kineses113111253kineses
kinesis11259593kinesis
kinos96626143kino__s
kiosk836233kios_k
kips106430513k__ips
kiss85227393k_is_s
kisses104217333kisses
kists95822113k_ists
klongs11436603klongs
kloofs13386353kloofs
knacks11428543knacks
knap105815403kn_ap_
knars94416113kn_ars
knaurs10466963knaurs
knaves13439523knaves
knawes13328393knawes
kneads11357093kneads
kneels10408933kneels
knees95114873kn_ees
knells10439253knells
knifes136210213knifes
knish1238603knis_h
knishes1438263knishes
knits93914743kn_its
knives13458553knives
knob107417013kno__b
knobby1732713knobby
knock10487963kno_ck
knoll9389603kno_ll
knolly13336133knolly
knopped16355443knopped
knot85630503kno__t
knotty13315223knotty
knout95018263kno_ut
know116115843kno__w
knower1337073knower
knowers1436333knowers
known12568343kno_wn
knurls10396243knurls
knurs94511153kn_urs
koans95818623k_oans
koas85635093k_o_as
kobos115616893k_obos
kobs105831083k_o_bs
koels94613903k_oels
kohls12437803k_ohls
kois85129393k_o_is
kojis16468433k_ojis
kolas94822233k_olas
kolos94921213k_olos
konks84917113k_onks
kooks85217263k_ooks
kop97440203k_o_p_
koph135816543k_o_ph
kophs145010933k_ophs
koppa13397293k_oppa
koppas14407603k_oppas
koras95927113k_oras
kors85933013k_o_rs
kos76944823k_o__s
kotos95717693k_otos
kreeps12427413kreeps
krises105016083krises
kroons103711243kroons
kussos10336423kussos
kvases13467103kvases
kvass12507273kvas_s
lisps76913903_lisps
loops75723963_loops
looses67328243looses
lops66043353_lo_ps
loses56742013_loses
loss45337963_los_s
loups75319623_loups
mioses84318853mioses
miosis83615163miosis
mops85940133_mo_ps
mosks116117003_mosks
moss67641033_mos_s
mosts76028543_mosts
myoses114013843myoses
myosis114012553myosis
naps66238583_n_aps
neaps75618323_neaps
neeps75617883_neeps
ness45526563_nes_s
nests55728003_nests
nips65830923_n_ips
nisus56014393_nisus
nobs66436903_no_bs
nocks115121013_nocks
nodes64633493_nodes
nods55838223_no_ds
nodus66315993_nodus
noels56418703_noels
noes45845393_no_es
noesis6311443_noesis
noggs75811183_noggs
nogs56534613_no_gs
noils55024333_noils
noirs55615463_noirs
noises65021853_noises
nolos54423353_nolos
nomas74726413_nomas
nomes74933123_nomes
nomos75919743_nomos
noms65636403_no_ms
nonas55126653_nonas
nones55639133_nones
nooks95420393_nooks
noons54125283_noons
nooses65623643nooses
nope65934193_no_pe
noris54928273_noris
norms76019303_norms
nos38859323_no__s
nose46739363_nos_e
nosed65524553_nosed
nosey85619883_nosey
nosh76223543_nos_h
noshes96618233_noshes
nosy76322893_nos_y
notes55034583_notes
nouns56717313_nouns
nous46136983_no_us
nouses64627163_nouses
novas85215363_novas
nows75738233_no_ws
nowts86915853_nowts
onos46229003ono__s
onuses65616253onuses
oops65232673__oops
ops56641253__o_ps
oses46641513__oses
plops95920333plo_ps
pomps115316193_pomps
poops94422413_poops
pops86340953_po_ps
poses74642763_poses
posts75228783_posts
props95726883pro_ps
proses84733473proses
prosos85718553prosos
pross76529403pros_s
ptoses83514673ptoses
ptosis83611823ptosis
pyknoses1783573pyknoses
pyknosis1753643pyknosis
pyoses114314303pyoses
pyosis114012123pyosis
rasps74316663_rasps
romps94617543_romps
rooses65526233rooses
roosts64916323roosts
roses56445773_roses
roups75118903_roups
scoops105414363scoops
scops95820193sco_ps
shops104222893sho_ps
sloops85513623sloops
slops75026013slo_ps
snaps74719563sn_aps
sneaps84510863sneaps
snips75818013sn_ips
snobs74716153sno_bs
snogs66017493sno_gs
snoods74312443snoods
snooks104412823snooks
snools65715873snools
snoop75317173snoop_
snoopy11449473snoopy
snoots64216663snoots
snores64324313snores
snorts64116493snorts
snots55225103sno_ts
snouts64915863snouts
snows84719883sno_ws
soaps75120713_soaps
sops65244563_so_ps
soups75322943_soups
stomps105612833stomps
stoops85917893stoops
stops74827283sto_ps
stoss54316343stos_s
stoups85313273stoups
stowps115710583stowps
swoops114910923swoops
swops105913973swo_ps
sysops1136013sysops
thesps11448263thesps
thorps113610893thorps
tops66248123_to_ps
toss45637973_tos_s
tromps104911703tromps
troops85712773troops
uncaps1039813uncaps
unrips8199453unrips
unzips17175273unzips
wasps106714693_wasps
whomps16457603whomps
whoops14487863whoops
whops135013933who_ps
whosis1237163whosis
wisps105214183_wisps
woops104917523_woops
wops96634153_wo_ps

Search took 7 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.203880251.2
2DLD Change Limit1127163075.76319558.6
3Display Results3073070.0963197.9
 (SQL Overall)1786913076.06229477.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.