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

199 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
naught10431249(None) 
aught95120701_aught
caught124911681caught
naughts11447511naughts
naughty14445621naughty
nought104713971nought
taught104312231taught
waught133811041waught
aughts104710242_aughts
bought125115642bought
claught1335102claught
dought114915522dought
draught12266982draught
faugh125712962faugh_
fought135112402fought
fraught14266362fraught
haugh125114052haugh_
haughs13408562haughs
haughty17334642haughty
laugh94414372laugh_
laughs10489022laughs
night94327852n_ight
nougat74712652nougat
noughts11478082noughts
ought95221542_ought
paughty16294322paughty
saugh95318402saugh_
saughs104812052saughs
saughy13507462saughy
sought106315062sought
uncaught1443622uncaught
untaught1243732untaught
waucht14399412waucht
waugh125411682waugh_
waughts14355962waughts
aargh96314083aargh_
abought1346153abought
agha87417303_a_gha
alight103816863alight
angst6415493_angst
argot67728653_argot
aright103817663aright
audit62527883_audit
auger64922473_auger
augite7312613_augite
augur64311213_augur
august739203_august
aunt46553653_au_nt
baguet9316103baguet
baht96740013ba__ht
bight118728843_bight
blight124114623blight
bough115719313bough_
boughs125414373boughs
bright124215923bright
brought13308693brought
brugh115414293brugh_
brughs12509063brughs
catgut9310803catgut
claucht1445583claucht
claughts1443383claughts
cough115819643cough_
coughs125514543coughs
daughter1344503daughter
daunt65929083dau_nt
daut56443563dau__t
dight104027003_dight
dough105217383dough_
doughs115912933doughs
doughty15436023doughty
doughy14499843doughy
draughts13284753draughts
draughty16233523draughty
drought12258883drought
eight94928053_eight
enough1045763enough_
enoughs1144633enoughs
faggot1139053faggot
fagot9323403fa_got
faucet115816553faucet
fault85428313fau_lt
fight124027093_fight
flight134014813flight
fraughts15214243fraughts
fright133715243fright
gadget93616183gadget
garget84327273garget
gauche1238563gauche
gaucho1256223gaucho
gauge76117903gaug_e
gauged94713473gauged
gauger84714853gauger
gauges85915993gauges
gault65128483gau_lt
gaunt65430403gau_nt
haunt85229133hau_nt
haut75949733hau__t
height134713433height
heugh125410923heugh_
heughs13516903heughs
hight125327233_hight
indraught1452473indraught
infight1437453infight
infought1543533infought
insight1137913insight
jaunt125025273jau_nt
kiaugh1442813kiaugh_
kiaughs1542283kiaughs
knight1438173knight
laigh95515923laigh_
laighs10508803laighs
laughed1235893laughed
laugher1136603laugher
laughter1245113laughter
light94429603_light
lough95118483lough_
loughs105014773loughs
maggot10311713maggot
magot8326393ma_got
mauger93813483mauger
maugre9308973maugre
maumet103518883maumet
maut65448453mau__t
might113827083_might
nacho105414383na_cho
nag46450813na_g__
nagged93916053nagged
nagger84016123nagger
naggy106612823na_ggy
nags55436023na_g_s
nah69847003na__h_
natant6318733natant
natch105018223natch_
naughtier1343103naughtier
naughties1344573naughties
naughtily1642283naughtily
nausea637313nausea
nautch1144813nautch
neigh94912383neigh_
neighs10387733neighs
nidget83715643nidget
nigh85220663n_igh_
nighs95013613n_ighs
nights104117723n_ights
nighty135611273n_ighty
nougats8427413nougats
nucha10229793n_ucha
nugget8311723nugget
nut36651963n_u__t
onslaught13122113onslaught
oughts104710183_oughts
parget94529393parget
plight123513363plight
pugh106619233_pugh_
retaught1244663retaught
right94430503_right
rough97819443rough_
roughs105416223roughs
roughy137010863roughy
sangh95517453sangh_
sanghs105312063sanghs
sauch104918773sauch_
sauchs115112233sauchs
sauger74316253sauger
sault55834963sau_lt
shaugh13287433shaugh_
shaughs14245283shaughs
sight94629293_sight
slight103416003slight
sough95320463sough_
soughs105115623soughs
sugh86423443_sugh_
sughs95313323_sughs
target75028903target
taunt55532283tau_nt
taut47048963tau__t
teugh95511613teugh_
thought14639143thought
tight93626503_tight
tough97321993tough_
toughs105414993toughs
toughy135911083toughy
ugh76520683__ugh_
ughs85410973__ughs
unbought1443773unbought
unfought1543553unfought
unsight1137483unsight
unsought1244243unsought
vault85823763vau_lt
vaunt85925313vau_nt
vugh117115723_vugh_
vughs12678743_vughs
wauchts15285283wauchts
waughted1643483waughted
weight133914183weight
wight123725573_wight
wright133713513wright
wrought14276933wrought
yacht13417393ya_cht

Search took 6 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.390458182.1
2DLD Change Limit1127161994.92322895.8
3Display Results1991990.0633158.7
 (SQL Overall)1786911995.37633238.7
 
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.