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

236 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
nontax134841(None) 
fontal9313142fontal
nona46929062non_a_
nonas55126652non_as
nonfan948292nonfan
nonfat9512182nonfat
nongay10169152nongay
nonman8412362nonman
nonpar8168992nonpar
nontaxes1537852nontaxes
nonwar9159422nonwar
nota46830772no_ta_
notal55221352no_tal
syntax1634302syntax
anta46839583_anta_
antae56828293_antae
antas55432033_antas
antitax1447853antitax
aorta55922573aorta_
aortae65115473aortae
aortal65217513aortal
aortas65417783aortas
banjax2234763banjax
bantam10314063bantam
bombax1935753bombax
bonita8312943bonita_
bonitas939453bonitas
bonsai838463bonsai
borax145918723bo_rax
bota66236503bo_ta_
botas75328783bo_tas
cantal84122033cantal
centai84814783centai
cental84420963cental
centas85020703centas
coax136922983co__ax
coital84117053coital
confab1347063confab
conga85419873conga_
congas94417033congas
contact1144020683contact
contain9315833contain
conte76633203cont_e
contes84432913contes
context163913433context
conto76027173cont_o
contos84923233contos
contra83314703contra
contras93015623contras
convex18367743convex
cortex15311473cortex
costa75523733costa_
costae85319683costae
costal85419513costal
costar85518613costar
cotan71521783co_tan
cotta75818573cotta_
cottae84615703cottae
cottar84613813cottar
cottas84615573cottas
dental74319173dental
dona55529633don_a_
donas65926473don_as
donate73619503donate
donga76718423donga_
dongas84914613dongas
donna66215033donna_
donnas75511323donnas
dotal64919623do_tal
eonian6311833eonian
foetal9311883foetal
font77143753font__
fonts86124753font_s
frontal1038363frontal
gonad75216053gon_ad
gonia64117533gonia_
handax1749583handax
hoax147718293ho__ax
honan85319773hon_an
honda9414983honda_
hondas10313353hondas
hosta85917833hosta_
hostas94515823hostas
iota45127833io_ta_
iotas54821113io_tas
jota116423623jo_ta_
jotas125717443jo_tas
junta123713673junta_
juntas134210503juntas
kantar10311153kantar
longan75612363longan
lota47233503lo_ta_
lotah85315853lo_tah
lotas55926303lo_tas
manta75629913manta_
mantas85725363mantas
menta74424423menta_
mental84521603mental
monad85519473mon_ad
monas74732153mon_as
montage101211713montage
montane91313623montane
monte75829773mont_e
montes84226933montes
month104818423mont_h
months113812933months
mortal84616853mortal
mortar83812043mortar
nana46632903nan_a_
nanas55928633nan_as
natal53921493n_atal
nectar838853nectar
neonatal844383neonatal
neonate7311333neonate
ninja1258093ninja_
ninjas1386303ninjas
ninth8314583nint_h
ninths936933ninths
nodal64717793no_dal
noetic8514043noetic
noma67529463no_ma_
nomad86016183no_mad
nomas74726413no_mas
nonage7313683nonage
nonart6319193nonart
nonbank1345903nonbank
noncash1245163noncash
nonce75719823non_ce
nonces84418833nonces
noncom1039683noncom
none45743173non__e
nonego737013nonego
nones55639133non_es
nonet54540843non_et
nonets64118703nonets
nonfact1248893nonfact
nonfans1037533nonfans
nonfarm1246513nonfarm
nonfatal1146053nonfatal
nongame1038183nongame
nongays11176533nongays
nonmeat9312773nonmeat
nonmen8412833nonmen
nonmetal1049643nonmetal
nonoral7313603nonoral
nonpaid1048073nonpaid
nonpast939033nonpast
nonpeak1345473nonpeak
nonplay1246683nonplay
nonstop9106923nonstop
nontidal948673nontidal
nontonal849743nontonal
nontoxic1746233nontoxic
nonuse63212253nonuse
nonvital1147023nonvital
nonwage1137163nonwage
nonwars10109003nonwars
nonyl849773non_yl
nonyls957853nonyls
noonday1144603noonday
nopal75517103no_pal
noria55722183noria_
norias65518203norias
normal83213533normal
north86018273nort_h
norths96812323norths
nostoc868193nostoc
not39474663no_t__
notary92310713no_tary
notate63217863no_tate
notch105613323no_tch
note46239963no_t_e
noted65123843no_ted
noter55025643no_ter
notes55034583no_tes
notum7611693no_tum
nougat74712653nougat
nounal639813nounal
nova76518953no_va_
novae85913123no_vae
novas85215363no_vas
noway111112843no_way
nowt78833753nowt__
nowts86915863nowt_s
nunatak1142673nunatak
octad81510653_octad
octal71214723_octal
octan71313483_octan
onlay84212943_onlay
ontic74418573_ontic
onto46127663_ont_o
onyx1478363_on_yx
ottar54313993_ottar
pentad9313763pentad
pinta75727053pinta_
pintas85021393pintas
poleax1547993poleax
pontes83627853pontes
pontil8315463pontil
ponton83217643ponton
portal84218463portal
postal84317533postal
posttax1645533posttax
pretax152310193pretax
qintar15359143qintar
rental63922023rental
retax124517973_retax
rota45834343ro_ta_
rotas54827723ro_tas
softa86415183softa_
softas94410403softas
sonar56523423son_ar
sonata6313223sonata
sonatas7510293sonatas
sorta57125413sorta_
suntan62613003suntan
surtax1337843surtax
tax109449153___tax
tonal53724303ton_al
tonga65619693tonga_
tongas74315523tongas
torta55925353torta_
tortas64918253tortas
total55321823to_tal
volta85215623volta_
vortex1635923vortex
wont75842503wont__
wonted103213283wonted
wonton93410963wonton
wonts87621543wont_s
yenta83917043yenta_
yentas94614213yentas
zona136321963zon_a_
zonae145116443zon_ae
zonal145116853zon_al
zonate154114923zonate

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 Limit1127162365.42320784.8
3Display Results2362360.0763105.3
 (SQL Overall)1786912365.88930343.2
 
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.