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

156 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
naughts1144751(None) 
aughts104710241_aughts
naught104312491naught_
naughty14445621naughty
noughts11478081noughts
waughts14355961waughts
aught95120702_aught_
caught124911682caught_
claughts1443382claughts
draughts13284752draughts
fraughts15214242fraughts
haughs13408562haugh_s
haughty17334642haughty
laughs10489022laugh_s
naughties1344572naughties
nights104117722n_ights
nougats8427412nougats
nought104713962nought_
oughts104710182_oughts
paughty16294322paughty
saughs104812052saugh_s
taught104312222taught_
wauchts15285282wauchts
waught133811042waught_
aghas97014873_a_ghas
alights113211433alights
angsts738863_angsts
argots74116033_argots
audits72814113_audits
augers73818703_augers
augite7312613_augite
augites8312183_augites
augurs7399963_augurs
august739203_august
aunts55227633_au_nts
baguets1037483baguets
bahts105617803ba__hts
bights124417963_bights
blights133110213blights
boughs125414373bough_s
bought125115633bought_
brights133710233brights
brughs12509063brugh_s
catguts1045323catguts
claught1335103claught_
coughs125514543cough_s
daughter1344503daughter
daughters1443993daughters
daunts75014083dau_nts
dauts67822243dau__ts
dights114016963_dights
doughs115912933dough_s
dought114915513dought_
doughty15436023doughty
draught12266963draught_
draughty16233523draughty
droughts13245733droughts
eights103618983_eights
enoughs1144623enough_s
faggots1234863faggots
fagots1039963fa_gots
faucets12578443faucets
faugh125712963faugh__
faults94513553fau_lts
fights133816553_fights
flights143310983flights
fought135112393fought_
fraught14266353fraught_
frights14339623frights
gadgets10348683gadgets
gargets94614573gargets
gauchos1345903gauchos
gaugers94211713gaugers
gauges85915993gaug_es
gaults74112783gau_lts
haugh125114053haugh__
haunts95614393hau_nts
heights14399443heights
heughs13516903heugh_s
hights133716893_hights
indraughts1551483indraughts
infights1545573infights
insights1245493insights
jaunts137511883jau_nts
kiaughs1542283kiaugh_s
knights1545653knights
laighs10508803laigh_s
laugh94414373laugh__
laughed1235893laughed
laugher1136603laugher
laughers1235923laughers
laughter1245113laughter
laughters1344593laughters
lights104519913_lights
loughs105014773lough_s
maggots1136563maggots
magots9312363ma_gots
maumets11369693maumets
mauts75927193mau__ts
mights123516253_mights
nachas114914193na_chas
naches114622413na_ches
nachos115014183na_chos
naggers93812653naggers
nags55436023na_g__s
naughtier1343103naughtier
naughtiest1442733naughtiest
naughtily1642283naughtily
nauseas735993nauseas
nautches1336083nautches
neighs10387733neigh_s
nidgets9358143nidgets
nighs95013613n_igh_s
night94327853n_ight_
nighty135611273n_ighty
nougat74712653nougat_
nuggets936383nuggets
nuts45032673n_u__ts
onslaughts14111323onslaughts
ought95221533_ought_
pargets105215193pargets
plights13299313plights
rights104019333_rights
roughs105416213rough_s
sanghs105312063sangh_s
sauchs115112233sauch_s
saugers83914053saugers
saugh95318403saugh__
saughy13507463saugh_y
saults65816173sau_lts
shaughs14245283shaugh_s
sights103818013_sights
slights112810723slights
soughs105115623sough_s
sought106315053sought_
sughs95313323_sugh_s
targets84314223targets
taunts65715663tau_nts
tauts56125513tau__ts
thoughts15515603thoughts
tights104015853_tights
toughs105414983tough_s
ughs85410973__ugh_s
uncaught1443623uncaught_
unsights1244623unsights
untaught1243723untaught_
vaults94511673vau_lts
vaunts95212623vau_nts
vughs12678743_vugh_s
waucht14399413waucht_
waugh125411683waugh__
waughted1643483waughted
weights14409553weights
wights133315783_wights
wrights14318993wrights
yachts1437023ya_chts

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271569.01614865.5
3Display Results1561560.0463391.3
 (SQL Overall)1786911569.21819385.0
 
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.