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

206 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
nosy7632289(None) 
cosy97232701cosy
noisy86813361noisy
nos38859321nos_
nose46739361nose
nosey85619881nosey
nosh76223541nosh
posy96028421posy
rosy76024871rosy
anomy105113392anomy
antsy85712792antsy
body107425672body
bogy106426192bogy
bony96732082bony
bos57966812bos_
bosh96328972bosh
bosk105825732bosk
bosky145612392bosky
boss65938342boss
bossy105515972bossy
bousy104917842bousy
boxy166420732boxy
boy87753562bo_y
boys96737332boys
brosy106115382brosy
busy94727172busy
coky137526822coky
coly96940532coly
cony96537832cony
copy116229802copy
cory96941512cory
cos510270392cos_
cosey106226712cosey
cosh96127622cosh
coss66143492coss
cost68057942cost
cowy126427362cowy
coy810557552co_y
coys97537242coys
cozy185823802cozy
doby106022162doby
dogy96126492dogy
donsy96414682donsy
dopy106224152dopy
dory85836232dory
dos48062312dos_
dose56442432dose
doss56235042doss
dost57248352dost
doty86128222doty
doxy156419952doxy
dozy175920322dozy
easy76224492easy
fogy115923182fogy
foss76431642foss
foxy176517752foxy
foy96044262fo_y
foys105628292foys
fozy197017162fozy
goby106021082goby
goosy96018882goosy
gorsy95915782gorsy
gory86129662gory
gos47155132gos_
gosh86123422gosh
goy77844552go_y
goys86328412goys
holy106333432holy
homy126623222homy
horsy116318392horsy
hos68364192hos_
hose76547242hose
hosey116127022hosey
host77852832host
hoy97447912ho_y
hoys107733932hoys
joey145719332joey
joky186215312joky
josh145117612josh
joss115925592joss
joy137036362jo_y
joys146624662joys
knosp11576822knosp
kos76944822kos_
koss85224812koss
logy87025782logy
lory75931712lory
lose45144582lose
loss45337962loss
lossy85214642lossy
lost47951492lost
lousy84617082lousy
moly96031912moly
mony96830002mony
mopy115721972mopy
mos57067122mos_
mosey105922872mosey
mosh95227602mosh
mosk105622442mosk
moss67641032moss
mossy105217062mossy
most66554202most
mousy106716942mousy
naos47429732naos_
nary76931222nary
nasty85717282nasty
navy107518632navy
nay66952772n_ay
nays75931592nays
ness45526562ness
nest45548732nest
newsy11489392newsy
nisi45823242nisi
nixy145714512nixy
no29353242no__
nob58954422no_b
nobby125513462nobby
nobly105314402nobly
nobs66436902nobs
nock106127182nock
nod47549562no_d
noddy105411202noddy
node513036882node
nodi56626742nodi
nods55838222nods
noel45226552noel
noes45845392noes
nog46847312no_g
nogg65115942nogg
nogs56534612nogs
noh66640642no_h
noil46133242noil
noily86120992noily
noir46722432noir
noise55723732noise
nolo46229312nolo
nom510450642no_m
noma67529462noma
nome66038422nome
noms65636402noms
nona46929062nona
none45743172none
nonyl849772nonyl
noo37154042no_o
nook85728492nook
nooky124814812nooky
noon47134622noon
noose55624062noose
nope65934192nope
nor38048822no_r
nori47133142nori
norm66429812norm
nosed65524552nosed
noses55435642noses
nosily93712682nosily
not39474662no_t
nota46830772nota
note46239962note
noun45724182noun
nous46136982nous
nova76518952nova
now65950192no_w
noway111112842noway
nows75738232nows
nowt78833752nowt
nus37939392nus_
nutsy85711502nutsy
only75319722only
onos46229002onos_
ons36148512ons_
oozy167018132oozy
os211359882_os_
ose38147342_ose
oxy136320982_oxy
oy58950132_o_y
poesy105014062poesy
pogy105623552pogy
poky135922152poky
poly96235152poly
pony96434052pony
popsy125713402popsy
pose66441732pose
posh95427322posh
post67953362post
potsy105815612potsy
poxy166820892poxy
prosy106319252prosy
ropy96323412ropy
rose46148902rose
snowy115011562snowy
sonsy86416372sonsy
sos37761602sos_
soy67851452so_y
soys75233932soys
toby96322292toby
tody86327212tody
tony75635152tony
tory75840542tory
tosh74826812tosh
toss45637972toss
tost48351922tost
towy105325472towy
toy69655192to_y
toys78036342toys
wos66953532wos_
wost76544362wost

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 Filter178691298720.0762351197.4
2DLD Change Limit298722061.00029872.0
3Display Results2062060.0464478.3
 (SQL Overall)1786912061.122159261.1
 
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.