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

226 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
nougat7471265(None) 
nougats8427411nougats
nought104713961nought
bought125115632bought
cougar958782cougar
dought114915512dought
forgat104018582forgat
fought135112392fought
naught104312492naught
nonfat9512182nonfat
nongay10169152nongay
noughts11478082noughts
nounal639812nounal
ought95221532_ought
sought106315052sought
abought1346143abought
ajuga1335883ajuga_
ajugas1435263ajugas
aoudad835033aoudad
aught95120703_aught
begat86629723_begat
boat66360313bo__at
bobcat12411253bobcat
bogan87519003bo_gan
bogart9617193bo_gart
bough115719313boug_h
boughs125414373boughs
bougie93613273bougie
bout66353293bou__t
brought13308683brought
caught124911683caught
coat67558343co__at
combat12316753combat
conga85419873conga_
congas94417033congas
cougars1038423cougars
cough115819643coug_h
coughs125514543coughs
count74932053cou_nt
courant9317973courant
court75532763cou_rt
cowpat13312033cowpat
doat56947673do__at
donga76718423donga_
dongas84914613dongas
doubt8720093dou_bt
dough105217383doug_h
doughs115912933doughs
doughty15436023doughty
doughy14499843doughy
doula65717773doula_
doulas75114993doulas
douma85817703douma_
doumas95314813doumas
doura66518663doura_
dourah10479813dourah
douras75016723douras
drought12258873drought
ducat86225903_ducat
enough1045753enoug_h
enoughs1144623enoughs
forget106326393forget
forgot104318133forgot
format113021353format
fount84727033fou_nt
frugal1036393frugal
fugal95613033_fugal
fugato1036223_fugato
gat46880513___gat
goat56250833go__at
gorget87123863gorget
gouge78220063goug_e
gouged96214593gouged
gouger86014363gouger
gouges86318693gouges
gout56646003gou__t
hogan97817703ho_gan
hogget114715763hogget
houdah1335173houdah
infought1543523infought
joual12311653jou_al
joust125122293jou_st
juga126417323_juga_
jugal135612403_jugal
jugate14379463_jugate
jurat124829323_jurat
knout95018263knou__t
korat94934433ko_rat
logan68123283lo_gan
loggats9286453loggats
longan75612363longan
loquat1558283loquat
lough95118483loug_h
loughs105014773loughs
louma76213633louma_
loumas84812333loumas
lout45952143lou__t
lovat8321043lo_vat
moat66352033mo__at
mongst93512603mongst
morgan9311373morgan
moult74728723mou_lt
mount74128063mou_nt
naughts11447513naughts
naughty14445623naughty
neat46356783n__eat
negate72915573n_egate
neural6311993neural
nidget83715633nidget
night94327853n_ight
nilgai734873nilgai
nilgau735113nilgau
nocent83217413nocent
nodal64717793no_dal
nodular876703nodular
nog46847313no_g__
nogg65115943no_g_g
nogged95716333nogged
noggin8288883noggin
noggs75811183no_ggs
nogs56534613no_g_s
noma67529463no_ma_
nomad86016183no_mad
nomas74726413no_mas
nona46929063no_na_
nonage7313683nonage
nonart6319193nonart
nonas55126653no_nas
nonet54540843no_net
nonfact1248893nonfact
nonfan948293nonfan
nongame1038173nongame
nongays11176533nongays
nonman8412363nonman
nonmeat9312773nonmeat
nonpar8168993nonpar
nonpast939033nonpast
nonsugar944363nonsugar
nontax1348413nontax
nonwar9159423nonwar
noogie73612313noogie
nopal75517103no_pal
noria55722183noria_
norias65518183norias
normal83213533normal
nosegay1143843nosegay
not39474663no___t
nota46830773no_ta_
notal55221353no_tal
notate63217863no_tate
noun45724183nou__n
nouns56717313nou_ns
nous46136983nou__s
nouses64627163nouses
nouveau1043953nouveau
nova76518953no_va_
novae85913123no_vae
novas85215363no_vas
noway111112843no_way
nowt78833753no__wt
nugget8311723nugget
numbat10312083numbat
nut36651963n_u__t
nutant6316383n_utant
nutate63017373n_utate
oat39888263_o__at
ogam75120033_o_gam
organ6915393_organ
orgeat7515033_orgeat
oughts104710183_oughts
oust46747443_ou_st
out38072153_ou__t
outact8317203_outact
outate62923403_outate
outeat62824533_outeat
outgas7313203_outgas
outsat62920283_outsat
poult76928873pou_lt
pout65752553pou__t
rotgut738793rotgut
rouge65423443roug_e
rouged86717323rouged
rouges76022383rouges
rough97819433roug_h
roughs105416213roughs
roughy137010853roughy
roupet84218343roupet
roust55532063rou_st
rout46153283rou__t
ruga56121233_ruga_
rugae65114763_rugae
rugal65916093_rugal
rugate75813813_rugate
snout54530633snou__t
snowcat1245333snowcat
soucar839323soucar
soudan73210353soudan
sough95320463soug_h
soughs105115623soughs
squat143720143squ_at
sugar6312913_sugar
taught104312223taught
thought14639133thought
toga57027413to_ga_
togae67020113to_gae
togas67823003to_gas
togate74515683to_gate
tomcat101013453tomcat
tonga65619683tonga_
tongas74315513tongas
toucan838193toucan
tough97321983toug_h
toughs105414983toughs
toughy135911073toughy
tout46753823tou__t
unbought1443763unbought
unfought1543543unfought
unsought1244233unsought
waught133811043waught
wombat1339863wombat
wrought14276923wrought
yoga87418053yo_ga_
yogas96615603yo_gas
yogurt1037823yogurt
yuga85615423_yuga_
yugas95012063_yugas

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.1401276364.3
2DLD Change Limit1127162265.51620434.4
3Display Results2262260.0633587.3
 (SQL Overall)1786912265.71931245.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.