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

356 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
narwal93894(None) 
narial6317951narial
narwals1036981narwals
narwhal1344331narwhal
areal55928732_areal
argal65023382_argal
artal55525472_artal
arval86017012_arval
barbal104016662barbal
carnal83919202carnal
carpal103716252carpal
earwax1664732earwax
farfal123410182farfal
hartal9415472hartal
larval948502larval
narwhale1443222narwhale
narwhals1443612narwhals
nasal56217592na_sal
nasial6413282nasial
natal53921492na_tal
naval85315832na_val
nawab10810922na_wab
normal83213532normal
parral85517532parral
tarnal63716502tarnal
tarsal63315272tarsal
aal39058673_a__al
aerial64625713aerial
airway1237693airway
algal66518213_algal
alway116113923_alway
anal48037523_a_nal
animal85016253animal
annal56520763_annal
anneal64812293anneal
annual64710703annual
anodal72512113anodal
antral65719413antral
anural65714743anural
anyway1534803anyway
aortal65217513aortal
appal95315223_appal
arak86929573_ar_ak
area45843393_area_
areae55229743_areae
areas55935773_areas
argala74712663_argala
argali75013743_argali
argals75517703_argals
argil65116883_argil
argol65317263_argol
arhat8327093_arhat
aria46245423_aria_
arias55438023_arias
ariel55228973_ariel
aril45843023_ar_il
arras55626133_arras
array86317143_array
artel56122743_artel
aryl75922343_ar_yl
atrial65418943atrial
aural54428963_aural
avowal1246323avowal
awa611939673_a_wa_
away108024223_a_way
awl67635303_a_w_l
awol75620673_a_wol
axal116520493_a_xal
axial124515193_axial
baal67033113ba__al
banal75925993ba_nal
barbel104317073barbel
barca91319433barca_
barcas101016603barcas
barman103519703barman
barrel84517873barrel
barware12610703barware
basal75722283ba_sal
bawl95326063ba_w_l
bharal1138893bhar_al
boral75831703bor_al
boreal84817213boreal
brawl106217963braw_l
burial84117623burial
bursal84414823bursal
cabal95222153ca_bal
caecal103713733caecal
canal75428043ca_nal
cantal84122033cantal
caracal11312503caracal
carat75048793car_at
caraway1538133caraway
carcel105018673carcel
carful11610973carful
carinal94318223carinal
carl65144783car__l
carman103920743carman
carol75128613car_ol
carpale113414353carpale
carpals113414623carpals
carpel105418473carpel
carrel84718633carrel
cartel85022533cartel
carvel114817573carvel
carwash1535993carwash
casual81112863casual
catwalk1645323catwalk
caudal91611483caudal
causal81413203causal
cercal10314123cercal
cereal8315833cereal
coral76033453cor_al
corral83616253corral
craal74117753_craal
crawl104916713craw_l
curial84019153curial
curtal83914543curtal
daedal849083daedal
darbar959953darbar
darnel74312183darnel
dermal93614343dermal
dorsal74613943dorsal
drawl95516013draw_l
dural64923893dur_al
earful958963earful
earl45838143ear__l
earlap837183earlap
earwig10114703earwig
facial113615633facial
faecal11359813faecal
fairway1644333fairway
fallal93612693fallal
farad95720673far_ad
faraway1645413faraway
fardel104712593fardel
farfals13268503farfals
farfel124310433farfel
farl76338553far__l
fatal84819373fa_tal
fatwa1168063fatwa_
fatwas1249053fatwas
faucal11339963faucal
faunal94711593faunal
feral85424653fer_al
ferial94621253ferial
formal113215203formal
gadwall1244563gadwall
garda7316763garda_
gardai839663gardai
gavial10310083gavial
gayal9312713ga_yal
gharial1137343gharial
gnarl65115573gnar__l
gnathal1144353gnathal
goral65125753gor_al
graal64316503_graal
gyral94412783gyr_al
hadal95518123ha_dal
haemal113811643haemal
halal85623593ha_lal
hallal94415563hallal
hamal104623103ha_mal
hammal134512063hammal
harl75740003har__l
hartals10313023hartals
hawala12368913ha_wala
herbal112513493herbal
horal86328673hor_al
irreal657823irreal
jacal14313703ja_cal
jackal1937613jackal
jarful1646683jarful
jarl115828133jar__l
jarrah1636683jarrah
jawan15710383ja_wan
jaywalk2442523jaywalk
jural125120483jur_al
karat96837593kar_at
karma113415003karma_
karmas123013733karmas
knawel13415413kna_wel
kraal94511823_kraal
labial84714333labial
laical8312323laical
lariat6629043lariat
larva8312483larva_
larvae938843larvae
larvas9310233larvas
loral55927823lor_al
loreal63814313loreal
mammal95112753mammal
manual8313463manual
mara67444563mar_a_
maras75443283mar_as
marcel103714853marcel
margay12310593margay
maria75032883maria_
marital92314183marital
marka114620793marka_
markas124717003markas
marl66341613mar__l
marram10313883marram
marsala939583marsala
marshal1238973marshal
martial92415413martial
marvel113712003marvel
moral75533433mor_al
mortal84616853mortal
mural75225103mur_al
naan47621933na__an
nachas114914193nachas
nada58022903na_da_
nadas66320813na_das
nadiral836343nadiral
naiad6313403na_iad
nail45838653na__il
naira5314743naira_
nairas6312773nairas
nakfa1236093nakfa_
nakfas1334683nakfas
nala46930393na_la_
nalas55528363na_las
nana46632893na_na_
nanas55928633na_nas
napa66927263na_pa_
napalm1047263na_palm
napas75924353na_pas
nappa98511863nappa_
nappas105511613nappas
narc67127953nar__c
narco76718243nar_co
narcos86714203narcos
narcs76122023nar_cs
nard56634453nar__d
nards65928463nar_ds
nares55544153nar_es
nargile847653nargile
naric76824173nar_ic
narine63422553narine
naris55735293nar_is
nark85230063nar__k
narked114116743narked
narks96026033nar_ks
narky126017803nar_ky
narrate7313493narrate
narrow9269143narrow
narwhales1543163narwhales
nary76931223nar__y
nasals63312463na_sals
natural739513natural
navar83912733na_var
navel87016573na_vel
naw66346493na_w__
nawabs1185063na_wabs
naysay1234973naysay
nerol51017813ner_ol
neural6311993neural
newel86114133n_ewel
nidal65217103n_idal
nival84915773n_ival
nodal64717793n_odal
nonwar9159423nonwar
nopal75517103n_opal
noria55722183noria_
norias65518183norias
normals92510903normals
notal55221353n_otal
notarial8410743notarial
nounal639813nounal
noway111112843n_oway
nuchal11218873nuchal
nurl45327243nur__l
oral47638123_or_al
ovarial1037613ovarial
paleal84716673paleal
palpal104112053palpal
papal95820673pa_pal
para65242173par_a_
parae76335703par_ae
paras76143043par_as
parcel103915473parcel
pardah123412823pardah
pariah114320583pariah
parian83223963parian
parka115120883parka_
parkas125018023parkas
parkway1934553parkway
parlay113713993parlay
parol74826273par_ol
parrals94414573parrals
parrel84515983parrel
partan83820563partan
partial92616263partial
partway1535923partway
pascal10812373pascal
pausal81511963pausal
pawl95123263pa_w_l
paxwax1742953paxwax
portal84218463portal
racial83419243racial
radial74020393radial
ramal74622243ra_mal
rascal8511123rascal
ratal55025113ra_tal
real45750293__real
rial45938093__rial
rural55821173rur_al
sabal75422483sa_bal
sacral83414413sacral
sahiwal1344443sahiwal
salal55425703sa_lal
sambal105215183sambal
sandal73317283sandal
saran53730303sar_an
sardar73013173sardar
sarsar63011843sarsar
scrawl11208083scrawl
seral56336383ser_al
serial64625853serial
serval93913413serval
snarl54921083snar__l
sprawl11188063sprawl
sural55931263sur_al
tamal73522613ta_mal
tarmac10310333tarmac
tarpan82814293tarpan
tarsals72512603tarsals
tartan64217513tartan
tartar63214753tartar
tarzan152910753tarzan
tergal72912833tergal
trawl84915873traw_l
trial54926353_trial
unreal64414453unreal
ureal56722683_ureal
urial54823023_urial
vagal94613633va_gal
valval12398863valval
vandal103713833vandal
vara75530883var_a_
varas86028193var_as
varia85824203varia_
varias95019903varias
varna84516173varna_
varnas94212823varnas
vasal85516293va_sal
vassal979243vassal
verbal112513663verbal
vernal93514213vernal
versal93013753versal
viral86419593vir_al
wadmal1237283wadmal
warsaw1236193warsaw
wawl105321943wa_w_l
yawl104918973ya_w_l
zoarial1646923zoarial

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 Limit1127163565.40620850.2
3Display Results3563560.1103236.4
 (SQL Overall)1786913565.65631593.2
 
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.