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

460 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
nasial641328(None) 
narial6317951narial
nasal56217591nas_al
axial124515192_axial
basal75722282bas_al
basil75122272basi_l
basinal9310032basinal
casual81112862casual
facial113615632facial
fascial1258302fascial
gavial10310082gavial
labial84714342labial
mesial84818082mesial
nadiral836342nadiral
naiad6313402na_iad
nail45838652na_i_l
narwal938942narwal
nasals63312462nas_als
nasion63914082nasion
natal53921492na_tal
naval85315832na_val
pascal10812372pascal
racial83419242racial
radial74020392radial
rascal8511122rascal
sial45938832__sial
vasal85516292vas_al
vassal979242vassal
aal39058673_a__al
abasia8712953abasia_
abasias9711013abasias
abaxial1646183abaxial
adagial946363adagial
adaxial1545323adaxial
aecial84817313aecial
aerial64625713aerial
ail37171043_a_i_l
algal66518213_algal
alias55834603_alias
amia66836903_amia_
amias75831473_amias
anal48037523_a_nal
anginal8310163anginal
anil46437433_ani_l
animal85016253animal
annal56520763_annal
anneal64812293anneal
annual64710703annual
anodal72512113anodal
ansa45927773ans_a_
ansae55720973ans_ae
antiar6317173antiar
antral65719413antral
anural65714743anural
anvil82712603anvi_l
apian75018333_apian
apical10913903_apical
appal95315223_appal
apsidal1046693apsidal
areal55928733_areal
argal65023383_argal
aria46245423_aria_
arias55438023_arias
ariel55228973_ariel
aril45843023_ari_l
artal55525473_artal
arval86017013_arval
asea46327183_asea_
aside65122083_aside
asocial998653_asocial
assai5711543_assai
assail6610153_assail
assay8710283_assay
astral66919283_astral
aswirl935093_aswirl
asyla839333_asyla
atrial65418943atrial
audial7312993audial
aural54428963_aural
avail8313883_avail
avian84616053_avian
axal116520493_a_xal
axil116424453_axi_l
baal67033113ba__al
bail65042803ba_i_l
banal75925993ba_nal
banian8315383banian
barbal104016663barbal
basalt83519583bas_alt
bashaw14349303bashaw
basic96220523basi_c
basics104915123basics
basidial1145623basidial
basify1437513basify
basilar937303basilar
basils85717473basils
basin75026923basi_n
basing95427663basing
basins85722763basins
basion84315853basion
basis75429863basi_s
bestial9311643bestial
biaxial1645363biaxial
brasil8713863brasi_l
burial84117623burial
byssal1134993byssal
cabal95222153ca_bal
caecal103713733caecal
camail10314823camail
cambial134010763cambial
canal75428043ca_nal
cantal84122033cantal
capias10318353capias
capital112311523capital
capsidal1345623capsidal
carinal94318223carinal
carnal83919203carnal
carpal103716253carpal
casa65630863cas_a_
casas75327843cas_as
casbah1337903casbah
cashaw14439793cashaw
casing94829103casing
casini84615863casini
casino84317553casino
casita82913703casita
casitas93312043casitas
cassia83714763cassia_
cassias93514343cassias
casuals91410523casuals
caudal91611483caudal
causal81413203causal
caviar11310163caviar
cavil103816493cavi_l
chasmal14158213chasmal
coastal9411033coastal
coaxial16157003coaxial
costal85419513costal
cranial92114683cranial
curial84019153curial
cuspal1037883cuspal
daedal849083daedal
datival1135583datival
deasil71110983deasi_l
denial74720513denial
dial55935063__dial
dismal92412243dismal
distal73615763distal
dossal75510303dossal
easel54521113eas_el
easier64218463easier
easies64126633easies
easily9313023easily
easing74926463easing
entasia73110063entasia_
entasias8269143entasias
espial839543espial
facia103218463facia_
faciae112913413faciae
facials123310743facials
facias113415803facias
faecal11359813faecal
fail74840243fa_i_l
fallal93612693fallal
farfal123410183farfal
fascia1148703fascia_
fasciae1247523fasciae
fascias1258413fascias
fatal84819373fa_tal
faucal11339963faucal
faucial1257323faucial
faunal94711593faunal
fecial114714623fecial
ferial94621253ferial
festal94213563festal
fetial95716193fetial
filial93013253filial
finial92814183finial
fiscal1139333fiscal
fusil84715323fusi_l
gasbag1035413gasbag
gasify1336333gasify
gasman92911743gasman
gastral8329553gastral
gavials1136603gavials
gayal9312713ga_yal
genial74917613genial
gharial1137343gharial
glacial1038143glacial
glial66715433_glial
gnathal1144353gnathal
gonadial1066823gonadial
gymnasial1551853gymnasial
hadal95518123ha_dal
haemal113811643haemal
hail74839063ha_i_l
halal85623593ha_lal
hallal94415563hallal
hamal104623103ha_mal
hammal134512063hammal
hartal9415473hartal
hassel95614213hassel
ilial55317843_ilial
incisal947373incisal
indusial966623indusial
initial7311883initial
instal6712183instal
jacal14313703ja_cal
jackal1937613jackal
jail115529093ja_i_l
jovial1636543jovial
kaiak8310353ka_iak
kail85131493ka_i_l
kalian10312163kalian
kasbah1535183kasbah
kasha124710723kasha_
kashas133311903kashas
labia75219013labia_
labials9299873labials
laical8312323laical
lamia75324323lamia_
lamiae84817453lamiae
lamias85020613lamias
laminal94113633laminal
lanital7310913lanital
lariat6629043lariat
larval948503larval
lascar868573lascar
lasing74727983lasing
mafia104418033mafia_
mafias113913573mafias
magian9312833magian
magical1239783magical
mail65543443ma_i_l
maill74420793ma_ill
mammal95112753mammal
mania75634143mania_
maniac103917973maniac
manias84029033manias
manila84518303manila
manual8313463manual
maria75032883maria_
marital92314183marital
marshal1238973marshal
martial92415413martial
masa65034713mas_a_
masala8311813mas_ala
masas75630413mas_as
massa75518923massa_
massas85116463massas
matinal9312603matinal
maximal18347093maximal
medial93819863medial
menial84223033menial
mescal104113483mescal
mesian84315503mesian
miasmal1176743miasmal
misdial1039643misdial
miskal123710263miskal
missal84314903missal
monaxial1745953monaxial
musical1139553musical
naan47621933na__an
nabis76020583nabi_s
nachas114914193nachas
nada58022903na_da_
nadas66320813na_das
nadir61012973nadi_r
nadirs7109003nadirs
naiads739013na_iads
naif76839023na_i_f
naifs87617423na_ifs
nails55730403na_ils
naira5314743na_ira
nairas6312773nairas
nairu5413813na_iru
naive85116213na_ive
nakfa1236093nakfa_
nakfas1334683nakfas
nala46930393na_la_
nalas55528363na_las
naming93917893naming
nana46632893na_na_
nanas55928633na_nas
nanism8311203nanism
naoi46024633naoi__
napa66927263na_pa_
napalm1047263na_palm
napas75924353na_pas
nappa98511863nappa_
nappas105511613nappas
naric76824173nari_c
narine63422553narine
naris55735293nari_s
narwals1036983narwals
narwhal1344333narwhal
nasally1057443nasally
nasions73112383nasions
nastic82915973nastic
nastier74115293nastier
nasties73520493nasties
nastily103011033nastily
nasty85717283nas_ty
nation64322803nation
national8311533national
native9613013native
natural739513natural
nauplial1042903nauplial
nausea637313nausea_
nauseas735993nauseas
nautical1057703nautical
navaid1037643navaid
navar83912733na_var
navel87016573na_vel
navies95218623navies
nawab10810923na_wab
naysaid1145303naysaid
naysay1234973naysay
nazi136219873nazi__
nazify2134233nazify
nazis145216083nazi_s
neural6311993neural
nidal65217103n_idal
nihil8410283nihi_l
nil36144193n__i_l
nill45634303n__ill
nisi45823243nisi__
nival84915773n_ival
nodal64717793n_odal
nodical1049863nodical
noil46133243n_oi_l
nominal92712373nominal
nopal75517103n_opal
noria55722183noria_
norias65518183norias
normal83213533normal
nosier63716323nosier
nosily93712683nosily
nosing73419843nosing
notal55221353n_otal
notarial8410743notarial
nounal639813nounal
nubia7311233nubia_
nubias8310093nubias
nuchal11218873nuchal
nuptial946633nuptial
oasis56422553oasi_s
ossia53710403ossia_
ovarial1037613ovarial
paginal10269493paginal
pail66141833pa_i_l
paisa76021073paisa_
paisan84417073paisan
paisas84317493paisas
paleal84716673paleal
pallial92911253pallial
palpal104112053palpal
papal95820673pa_pal
pariah114320583pariah
parian83223963parian
parral85517533parral
partial92616263partial
pascals11610013pascals
paschal14157243paschal
pasha105417183pasha_
pashas115117063pashas
passel85117003passel
pasta76624533pasta_
pastas85422873pastas
pastel85918713pastel
pastil85018323pastil
pausal81511963pausal
penial84120893penial
phaseal1245673phaseal
phial10313203_phial
pial65636703__pial
postal84317533postal
rachial122012173rachial
radiale83813523radiale
radials83614633radials
radian74117273radian
radical103312793radical
raia46638383ra_ia_
raias54631123ra_ias
rail46147763ra_i_l
ramal74622243ra_mal
rascals959663rascals
rasing74330833rasing
rasorial848223rasorial
ratal55025113ra_tal
redial74923113redial
resail64418733resail
reseal64819643reseal
retial64724993retial
rial45938093__rial
sabal75422483sa_bal
sacral83414413sacral
sahiwal1344443sahiwal
sail45447163sa_i_l
sal36462883__s_al
salal55425703sa_lal
sambal105215183sambal
samiel8313333samiel
sandal73317283sandal
sashay1238363sashay
sasin54626573sasi_n
sasins64923103sasins
seal45654373__seal
serial64625853serial
sials54227243__sials
sill45545153__sill
sisal54217733__sisal
snail57020203sna_i_l
social8813333social
spacial1138763spacial
spatial9310323spatial
tafia84215493tafia_
tafias93111963tafias
tahsil936343tahsi_l
tail45443653ta_i_l
tamal73522613ta_mal
tarnal63716503tarnal
tarsal63315273tarsal
tarsia65514273tarsia_
tarsias74013373tarsias
tassel66014773tassel
telial65815363telial
tibial849843tibial
trial54926353_trial
tussal6288323tussal
uncial83715223uncial
uniaxial1543883uniaxial
unseal63315473unseal
unusual743943unusual
urial54823023_urial
usual5310183_usual
vagal94613633va_gal
vaginal11288403vaginal
vail75432553va_i_l
vakil1259793vaki_l
valval12398863valval
vandal103713833vandal
varia85824203varia_
varias95019903varias
vasa76522973vas_a_
vassals1057953vassals
vatical1239983vatical
venial94218283venial
vesical12159813vesical
vestal94615573vestal
vial76731093__vial
visual938803visual
wadmal1237283wadmal
wail75238823wa_i_l
wassail1056133wassail
xenial133414903xenial
yasmak1534593yasmak
zamia165115213zamia_
zamias174212923zamias
zoarial1646923zoarial

Search took 8 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.1231452772.4
2DLD Change Limit1127164606.81316544.3
3Display Results4604600.1403285.7
 (SQL Overall)1786914607.07625253.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.