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

260 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
narwals103698(None) 
narwal938941narwal_
narwhals1443611narwhals
argals75517712_argals
carpals113414632carpals
farfals13268502farfals
hartals10313022hartals
narial6317952narial_
narwhal1344332narwhal_
narwhale1443222narwhale
narwhales1543162narwhales
nasals63312462na_sals
nawabs1185062na_wabs
normals92510902normals
parrals94414572parrals
tarsals72512602tarsals
aals49941143_a__als
aerials74017553aerials
airways1336243airways
always12409133_always
animals94111703animals
annals66415923_annals
anneals7449943anneals
annuals7388193annuals
anyways1644423anyways
appals104812943_appals
araks94820883_ar_aks
areal55928733_areal_
areas55935773_area_s
argal65023393_argal_
argala74712673_argala
argalas84011093_argalas
argali75013753_argali
argalis84214193_argalis
argils75213623_argils
argols74514613_argols
arhats9312973_arhats
arias55438023_aria_s
ariels65119373_ariels
arils58732203_ar_ils
arras55626133_arra_s
arrays95311683_arrays
artal55525473_artal_
artels66216233_artels
arval86017013_arval_
aryls87015813_ar_yls
avowals1335013avowals
awls75926093_a_w_ls
awols84713523_a_wols
baals76122703ba__als
barbal104016663barbal_
barbels114514433barbels
barcas101016603barca_s
barrels94514363barrels
barware12610703barware
barwares13610093barwares
bawls105719323ba_w_ls
bharals1236733bhar_als
borals86721913bor_als
brawls115214333braw_ls
burials93612083burials
cabals104020153ca_bals
canals84421673ca_nals
cantals93919573cantals
caracals12310763caracals
carats85929023car_ats
caraways1636953caraways
carcass11310513carcass
carcels114516063carcels
carfuls1249133carfuls
carls77037423car__ls
carnal83919213carnal_
carols85124983car_ols
carpal103716253carpal_
carpale113414353carpale
carpels115315463carpels
carrels95117303carrels
cartels94618123cartels
carvels124914593carvels
carwash1536003carwash
casuals91410533casuals
catwalk1645323catwalk
catwalks1744793catwalks
causals91411183causals
cereals9313173cereals
corals85325143cor_als
corrals93713853corrals
craals84113303_craals
crawls114712083craw_ls
curtals93111623curtals
darbars10510093darbars
darnels83710433darnels
dorsals84110853dorsals
drawls105511393draw_ls
earfuls1036863earfuls
earlaps936393earlaps
earls56127513ear__ls
earwax1664733earwa_x
earwaxes1844703earwaxes
earwigs11104413earwigs
facials123310743facials
fairways1743873fairways
fallals103310193fallals
farads104713273far_ads
fardels11389893fardels
farfal123410183farfal_
farfels13348213farfels
farls85731113far__ls
fatwas1249053fatwa_s
faucals12326563faucals
ferals94216643fer_als
formals123312893formals
gadwall1244563gadwall
gadwalls1343873gadwalls
gavials1136603gavials
gayals1039513ga_yals
gharials1245123gharials
gnarls74210773gnar__ls
gorals76917653gor_als
graals74112913_graals
halals95018313ha_lals
hamals114816833ha_mals
hammals14409233hammals
harass9313943har_ass
hardass1139753hardass
harls85634503har__ls
hartal9415473hartal_
hawala12368913ha_wala
hawalas13348353ha_walas
herbals122710613herbals
jacals1539873ja_cals
jackals2036893jackals
jarfuls1754773jarfuls
jarls126120963jar__ls
jarrahs1735453jarrahs
jawans1657843ja_wans
jaywalk2442523jaywalk
jaywalks2542143jaywalks
karats106420493kar_ats
karmas123013733karma_s
knawels14344683kna_wels
kraals10378433_kraals
labials9299873labials
lariats7615053lariats
larval948503larval_
larvas9310233larva_s
mammals10389273mammals
manuals9311223manuals
maras75443293mar_a_s
marcels113212373marcels
margays1337493margays
markas124717003marka_s
marls75535163mar__ls
marrams11310123marrams
marsala939583marsala
marsalas1038253marsalas
marshals1337783marshals
marvels123810093marvels
morals85324643mor_als
mortals93914013mortals
murals84016763mur_als
naans55815253na__ans
nachas114914193nacha_s
nadas66320813na_da_s
naiads739013na_iads
nails55730403na__ils
nairas6312783naira_s
nakfas1334683nakfa_s
nalas55528363na_la_s
nanas55928633na_na_s
napalm1047263na_palm
napalms1144033na_palms
napas75924353na_pa_s
nappas105511613nappa_s
narcos86714203nar_cos
narcs76122023nar__cs
nards65928463nar__ds
nares55544153nar__es
nargile847653nargile
nargiles976793nargiles
naris55735293nar__is
narks96026033nar__ks
narrate7313493narrate
narrates8312763narrates
narrows10258843narrows
nasal56217593na_sal_
nasial6413283nasial_
natal53921493na_tal_
naturals847903naturals
naval85315833na_val_
navars92810573na_vars
navels95712693na_vels
nawab10810923na_wa_b
naysays1344123naysays
nerols6914883ner_ols
newels93710823n_ewels
nonwars10109003nonwars
nopals84914023n_opals
norias65518203noria_s
normal83213533normal_
noways12127733n_oways
nuchals12216933nuchals
nurls55519683nur__ls
orals55826483_or_als
paras76143043par_a_s
parcels113712663parcels
pardahs13289673pardahs
pariahs123812343pariahs
parians93519733parians
parkas125018023parka_s
parkways2043973parkways
parlays123910453parlays
parols84722613par_ols
parral85517533parral_
parrels94713493parrels
partans94418283partans
partials101911963partials
pascals11610013pascals
pawls105617663pa_w_ls
portals94015563portals
radials83614643radials
rascals959663rascals
ratals64219583ra_tals
reals55038653__reals
rials55026673__rials
sabals84618863sa_bals
sacrals93311793sacrals
sahiwals1443643sahiwals
salals65120083sa_lals
sambals115213483sambals
sandals82715203sandals
sarans64224433sar_ans
sardars83112903sardars
sarsars73512143sarsars
scrawls12177283scrawls
serials73919753serials
servals103410753servals
snarls64016873snar__ls
sprawls12176373sprawls
tamals84116633ta_mals
tarmacs1138323tarmacs
tarnal63716503tarnal_
tarpans92513533tarpans
tarsal63315273tarsal_
tartans72615823tartans
tartars73313403tartars
tarzans16329923tarzans
trawls94412393traw_ls
trials64319883_trials
urials64415193_urials
vandals113211663vandals
varas86028193var_a_s
varias95019903varia_s
varnas94212823varna_s
vassals1057953vassals
verbals121910743verbals
wadmals1335513wadmals
warsaws1335763warsaws
wawls115416473wa_w_ls
yawls114613603ya_w_ls

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272607.09318895.7
3Display Results2602600.0932795.7
 (SQL Overall)1786912607.59223536.7
 
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.