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

257 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
nonwar915942(None) 
nonpar8168991nonpar
nonwars10109001nonwars
jowar155211432jo_war
nona46929062non_a_
nonart6319192non_art
nonas55126652non_as
nonfan948292nonfan
nonfarm1246512nonfarm
nonfat9512182nonfat
nongay10169152nongay
nonman8412362nonman
nontax1348412nontax
nonwage1137162nonwage
nonword1149152nonword
nonwork1448422nonwork
noway111112842no_way
onward1039052_onward
sonar56523422son_ar
sowar85821342so_war
anear55420323_anear
antiwar1037963antiwar
boar66134293bo__ar
bolar75123473bo_lar
bonder95324783bonder
boner75133083bon_er
bonier84321993bonier
bonsai838463bonsai
bonzer175313673bonzer
bower107328183bo_wer
boxcar1734753boxcar
boyar106013763bo_yar
cogway1566183cogway
collar83816173collar
concur10411103concur
condor94616973condor
confab1347063confab
confer114018683confer
conga85419873conga_
congas94417033congas
conger95024273conger
conker124721553conker
conner84423963conner
contra83314703contra
costar85518613costar
cottar84613813cottar
cougar958783cougar
coward12411673co_ward
cower104531773co_wer
denar65223293den_ar
dewar95817733_dewar
dinar66319893din_ar
dogear838193dogear
dollar74110983dollar
dona55529633don_a_
donas65926473don_as
donga76718423donga_
dongas84914613dongas
donna66215033donna_
donnas75511323donnas
donor64418193don_or
dower95027703do_wer
downer104414923downer
downward1644443downward
eonian6311833eonian
foliar93210973foliar
fonder104120063fonder
fontal9313143fontal
forward1438293forward
gnar56021383_gn_ar
gonad75216053gon_ad
goner66025163gon_er
gonia64117533gonia_
gowan95415743go_wan
hangar104114523hangar
hoar76729163ho__ar
honan85319773hon_an
honda9414983honda_
hondas10313353hondas
honer85332093hon_er
honker134117463honker
honor85718623hon_or
honour94710863honour
invar839513_invar
inward10310333_inward
ironware1144653ironware
jowars16369653jo_wars
kantar10311153kantar
knar85818723_kn_ar
knower1337083kno_wer
linear65113343linear
lobar7313013lo_bar
logway1335913logway
loner55431043lon_er
longan75612363longan
longer75823203longer
lower85830413lo_wer
lunar57017313lun_ar
manward1349093manward
molar75223093mo_lar
monad85519473mon_ad
monas74732153mon_as
monger94418333monger
moonward1474473moonward
mortar83812043mortar
mower104523453mo_wer
nana46632903nan_a_
nanas55928633nan_as
narwal938943narwal
navar83912733n_avar
nawab10810923n_awab
near45236503__near
nectar838853nectar
newer85717463n_ewer
ninja1258093ninja_
ninjas1386303ninjas
nobler83713453nobler
nodal64717793no_dal
nodder84811943nodder
nodular876703nodular
noir46722433no__ir
noma67529463no_ma_
nomad86016183no_mad
nomas74726413no_mas
nonage7313683nonage
nonarts7311303non_arts
nonbank1345903nonbank
noncash1245163noncash
nonce75719823non_ce
nonces84418833nonces
noncom1039683noncom
noncore9411953noncore
nondairy1244713nondairy
none45743173non__e
nonego737013nonego
nones55639133non_es
nonet54540843non_et
nonets64118703nonets
nonfact1248893nonfact
nonfans1037533nonfans
nongame1038183nongame
nongays11176533nongays
nonglare946373nonglare
nonhardy1544333nonhardy
nonhero1057913nonhero
nonjury1744033nonjury
nonlabor1044843nonlabor
nonmajor1743663nonmajor
nonmeat9312773nonmeat
nonmen8412833nonmen
nonoral7313603nonoral
nonowner1145253nonowner
nonpaid1048073nonpaid
nonparty1345553nonparty
nonpast939033nonpast
nonpeak1345473nonpeak
nonplay1246683nonplay
nonpolar1046283nonpolar
nonpoor956483nonpoor
nonsolar847083nonsolar
nonsugar944363nonsugar
nonuse63212253nonuse
nonuser7299143nonuser
nonwool1046673nonwool
nonwords1247463nonwords
nonyl849773non_yl
nonyls957853nonyls
nonzero1646123nonzero
noonday1144603noonday
nooser65517823nooser
nopal75517103no_pal
nor38048823no___r
noria55722183noria_
norias65518203norias
normal83213533normal
nosher94616363nosher
nosier63716333nosier
nota46830773no_ta_
notal55221353no_tal
notary92310713no_tary
noter55025643no_ter
nother93815963nother
nougat74712653nougat
nounal639813nounal
nova76518953no_va_
novae85913123no_vae
novas85215363no_vas
now65950193no_w__
noways12127733no_ways
nows75738233no_w_s
nowt78833753no_w_t
nowts86915863no_wts
oar37057953_o__ar
onlay84212943_onlay
onwards1137173_onwards
osar46820953_o_sar
ottar54313993_ottar
outwar91011513outwar
owner84613313_owner
polar75623453po_lar
ponder94521693ponder
poniard1037583poniard
poplar103611113poplar
postwar1236903postwar
power105325953po_wer
prewar114712583prewar
prowar114110943prowar
psywar1443323psywar
qindar16317173qindar
qintar15359143qintar
roar46328573ro__ar
rowan85418733ro_wan
rower85430493ro_wer
runway12105973runway
sangar73617693sangar
sansar63613393sansar
sewar85421103_sewar
soar46838673so__ar
sofar86115493so_far
solar55927343so_lar
sonars64818973son_ars
sonder73623523sonder
soucar839323soucar
sowars94318013so_wars
sowcar1135863sowcar
sower85229313so_wer
sunward1137653sunward
tinware1038603tinware
tolar55524113to_lar
tonal53724303ton_al
tonearm937443tonearm
toner55336243ton_er
tonga65619703tonga_
tongas74315533tongas
tonger74719693tonger
tonier65520713tonier
tonner64819203tonner
toward10311063to_ward
tower85729203to_wer
townwear1442293townwear
ulnar56013983uln_ar
unbar71913613_unbar
unwary1239823_unwary
vanward1456943vanward
volar86917413vo_lar
vower115220793vo_wer
war67262423___war
wonder103617813wonder
wonner95114443wonner
yonder103214133yonder
yonker134110853yonker
zona136321963zon_a_
zonae145116443zon_ae
zonal145116853zon_al
zonary1838793zon_ary
zoner144520343zon_er
zonular1656493zonular

Search took 7 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.420425454.8
2DLD Change Limit1127162575.69019809.5
3Display Results2572570.0763381.6
 (SQL Overall)1786912576.18628886.4
 
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.