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

323 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
neat4635678(None) 
beat66168301beat
eat36989051_eat
feat76458221feat
heat77061421heat
meat66359601meat
neap66927011neap
near45236501near
neath86020281neath
neats55931901neats
nest45548731nest
net36670291ne_t
nett46643231nett
newt76933741newt
next116631081next
peat65967931peat
seat47575561seat
teat45963631teat
anear55420322anear
anent54931842anent
at212393402__at
bat510988952_bat
bead75937922bead
beak106534382beak
beam86939232beam
bean66443862bean
bear66844642bear
beast76338642beast
beats76042242beats
beau66137272beau
beaut75135212beaut
beet66457542beet
begat86629722begat
belt65754032belt
bent67759912bent
best66355322best
bet58376672be_t
beta66234132beta
blat66550952blat
bleat75737002bleat
boat66360312boat
brat66055542brat
cat58282342_cat
celt65646712celt
cent67451012cent
chat95546132chat
cheat105732452cheat
cleat76335062cleat
coat67558352coat
dead65434242dead
deaf85838402deaf
deal56347412deal
dealt65234282dealt
dean56039482dean
dear55343602dear
death94822522death
debt77139022debt
deet57356582deet
defat95426692defat
deft85540222deft
delt57855272delt
dent57158412dent
derat65044082derat
doat56947672doat
drat56247832drat
ear36867882_ear
east46659102_east
eath75735662_eath
eats47054872_eats
eau37450942_eau
eft66038822_eft
enact73525362enact
enate54428142enate
et26964192_e_t
eta35834192_eta
fat68178082_fat
feal713940422feal
fear75337792fear
feast85932722feast
feats86432752feats
feet75352212feet
felt75146932felt
fest74949442fest
fet66471632fe_t
feta76528902feta
fiat76646642fiat
flat77147822flat
frat75648542frat
gat46880512_gat
gear55934972gear
gelt56448012gelt
gent56954392gent
gest56149132gest
get47467462ge_t
geta56627442geta
ghat86435282ghat
gnat56034432gnat
goat56250832goat
grat55651282grat
great66034242great
haet75659502haet
hat67289962_hat
head87137172head
heal75645692heal
heap96432892heap
hear76143882hear
heart85440742heart
heath115724282heath
heats85838402heats
heft106736292heft
hent76656382hent
hest75950772hest
het67674312he_t
ikat87626642ikat
inept73622152inept
inert53234372inert
jean116629282jean
jest116738502jest
jet106754822je_t
kat77468292_kat
kea76540912kea_
keas86337092keas
keet85347332keet
kelt85343192kelt
kent86846962kent
kept106232942kept
khat116730722khat
knead10429662knead
knelt94617682knelt
kyat116025522kyat
lat37593402_lat
lea37660182lea_
lead56038852lead
leaf76441032leaf
leak86233712leak
leal46043272leal
lean46345242lean
leant56737782leant
leap66032682leap
leapt75027472leapt
lear47045952lear
leas45954182leas
least56134882least
leet45957902leet
left76340482left
lent46360532lent
lept66440882lept
lest46956322lest
let36481472le_t
mat58083942_mat
mead75531602mead
meal65643172meal
mean65538092mean
meant76537212meant
meats75034052meats
meaty107021312meaty
meet65350552meet
melt65752892melt
met56072432me_t
meta65932412meta
moat66352032moat
na28652482n_a_
naan47621932naan
nab56954922n_ab
nae35952742n_ae
nag46450812n_ag
nah69847002n_ah
nam55953392n_am
nan37854882n_an
nap56753202n_ap
naw66346492n_aw
nay66952772n_ay
ne27045102ne__
neaps75618322neaps
nears55529422nears
neaten64214542neaten
neater64424312neater
neatly93812482neatly
neb57238622ne_b
nebs66124982nebs
neck105423662neck
nee36657782ne_e
need54934152need
neem67328082neem
neep65728312neep
neg47237342ne_g
negate72915572negate
negs55727362negs
neif75429492neif
neist54628442neist
nema65522522nema
nemas75321572nemas
nene45932062nene
neon47026422neon
nerd56624942nerd
nerts55924982nerts
nertz145117452nertz
ness45526562ness
nests55728002nests
nets45941532nets
netts55320722netts
netty85816762netty
neuk87416602neuk
neum66723082neum
neve76224832neve
nevi75116422nevi
new66237092ne_w
news76127372news
newts86015282newts
nit37065942n_it
not39474662n_ot
nota46830772nota
nowt78833752nowt
nut36651962n_ut
oat39888262_oat
pat58089462_pat
pea56657242pea_
peag75431342peag
peak106535202peak
peal68648102peal
pean66147172pean
pear69745232pear
peart76440752peart
peas65755062peas
peats76140192peats
peaty105725692peaty
pelt67651082pelt
pent66559072pent
pert66759322pert
pest65555292pest
pet56477302pe_t
phat95837862phat
plat66048872plat
pleat74734472pleat
prat65952042prat
qat125253332_qat
rat37892742_rat
react74634332react
read55942532read
real45750292real
ream65841612ream
reap65934742reap
rear45644552rear
reata54225392reata
reft75141272reft
rent46661242rent
resat55139682resat
rest46459842rest
ret35982832re_t
sat36288482_sat
scat65848372scat
sea36161292sea_
seal45654372seal
seam66645972seam
sear47353842sear
seas45755272seas
seats54844342seats
sect67443622sect
sent46963012sent
sept65844362sept
set36681252se_t
seta45637312seta
sett45949052sett
sext117338092sext
shat76456602shat
skat87037902skat
slat46959022slat
sneak96016172sneak
sneap75514822sneap
spat66548522spat
stat47352692stat
swat77244442swat
sweat85628402sweat
tat37690292_tat
tea37353322tea_
teak85930842teak
teal45546502teal
team66238652team
tear45242882tear
teas45851492teas
teats55636812teats
tent46159862tent
test48651622test
tet39274992te_t
text116033932text
that75639322that
treat56240352treat
twat75831512twat
unhat81119262unhat
unseat64221022unseat
vat67863452_vat
veal76936812veal
vent76049052vent
vert77249372vert
vest75743602vest
vet65958522ve_t
vext146927762vext
wat67378922_wat
weak117126302weak
weal75838682weal
wean75734352wean
wear75836722wear
weet75254152weet
weft105435012weft
welt75547862welt
went76051872went
wept95635052wept
wert79749822wert
west75748082west
wet65966622we_t
what105434072what
wheat114924572wheat
yea66445752yea_
yeah106725412yeah
yean75834582yean
year76534252year
yeas78638422yeas
yeast85327942yeast
yet66960692ye_t
yett76434492yett
zeal135530332zeal
zest136035702zest
zeta135121642zeta

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 Limit298723230.90632971.3
3Display Results3233230.0764250.0
 (SQL Overall)1786913231.058168895.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.