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

208 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
napalm104726(None) 
napalms1144031napalms
copalm125010812copalm
napa66927262napa__
napalmed1342502napalmed
napas75924352napa_s
nasal56217592nasal_
nasals63312462nasals
natal53921492natal_
naval85315832naval_
nopal75517102nopal_
nopals84914022nopals
palm85331362__palm
papal95820672papal_
tapalo839792tapalo
aal39058673_a_al_
aals49941143_a_als
alarm76621423_alarm
anal48037523_anal_
annal56520763annal_
annals66415923annals
apace94718383_apace
apart74330673_apart
appal95315223appal_
appall10379743appall
appals104812943appals
apple94517673_apple
apply125111393_apply
aptly105111813_aptly
axal116520493_axal_
baal67033113ba_al_
baalim1038473ba_alim
baals76122703ba_als
balm85534203__balm
banal75925993banal_
basal75722283basal_
basalt83519583basalt
becalm1239203becalm
cabal95222153cabal_
cabala103516913cabala
cabals104020153cabals
calm85032363__calm
canal75428043canal_
canals84421673canals
capable13313363capable
capably1639253capably
carpal103716253carpal_
carpale113414353carpale
carpals113414633carpals
catalo8314853catalo
copal95621783copal_
copalms13367543copalms
copals105018943copals
dapple1138853dapple
embalm1236653embalm
empale102611263empale
fatal84819373fatal_
gayal9312713gayal_
gayals1039513gayals
hadal95518123hadal_
halal85623593halal_
halala94715093halala
halals95018313halals
halm95834973__halm
hamal104623113hamal_
hamals114816833hamals
hapax1739323hapa_x
haply135915063hap_ly
haulm104415413ha_ulm
hawala12368913hawala
imbalm1246323imbalm
impala10256943impala
impale102811663impale
inaptly1244413inaptly
jacal14313703jacal_
jacals1539873jacals
japan14411233japa_n
japans1539823japans
kabala124011553kabala
kalam11315113kala_m
kamala12339963kamala
kapa106021293kapa__
kapas116021733kapa_s
ladypalm1651583ladypalm
lapel73716683lapel_
lapels83712043lapels
madam10316223mada_m
malm85129983__malm
maple95521143map_le
masala8311813masala
naan47621933na_a_n
naans55815253na_ans
nada58022903nada__
nadas66320813nada_s
nagana748943nagana
naiad6313403naia_d
naiads739013naiads
nail45838653na_il_
nails55730403na_ils
nala46930393n__ala
nalas55528363nala_s
nam55953393n__a_m
namable11312343namable
namely113711323namely
nana46632903nana__
nanas55928633nana_s
nanism8311203nanism
nap56753203nap___
napalming1443173napalming
nape65230803nap__e
napery11489813napery
napes74828463nap_es
napkin1236903napkin
nappa98511863nap_pa
nappas105511613nappas
nappe96114993nap_pe
napped114218163napped
napper103718283napper
nappes104515623nappes
nappie104112263nappie
nappy126312333nap_py
naps66238583nap__s
narial6317953narial_
narwal938943narwal_
narwals1036983narwals
nasalism1048203nasalism
nasally1057443nasally
nasial6413283nasial_
natant6318733natant
navaid1037653navaid
navally1366473navally
navar83912733nava_r
navars92810573navars
navel87016573navel_
navels95712693navels
nawab10810923nawa_b
nawabs1185063nawabs
nidal65217103nidal_
nipa69421633nipa__
nipas77116673nipa_s
nipple103410373nipple
nival84915773nival_
nizam16310253niza_m
nodal64717793nodal_
nopales93812523nopales
notal55221353notal_
nyala836823n_yala
opal66923523_opal_
opals75718353_opals
pal56761673__pal_
pale66055013__pale
pall65039343__pall
palms94921753__palms
palmy126016733__palmy
palp85828573__palp
palpal104112053palpal_
pals66951353__pals
paly95835533__paly
pam77858393__pa_m
papa85827143papa__
papacy1547493papacy
papadam1486913papadam
papadom1466763papadom
papadum1475233papadum
papain10313793papain
papally1437973papally
papas94927493papa_s
papaw125112493papa_w
papaws13419113papaws
papaya1337503papaya
papism122211513papism
papula103011113papula
papule102212133papule
pipal95118353pipal_
pipals104213643pipals
psalm949273_psalm
pupal97616873pupal_
qabala17399193qabala
qualm163511183_qualm
ramal74622243ramal_
raptly11338913raptly
ratal55025113ratal_
ratals64219583ratals
realm75621623_realm
sabal75422483sabal_
sabals84618863sabals
salaam8711013salaam
salal55425703salal_
salals65120083salals
sepal77723003sepal_
sepals85217383sepals
spale74929213_spale
spall74919303_spall
spam85930043_spa_m
spasm94514173_spasm
tamal73522623tamal_
tamale83717403tamale
tamals84116633tamals
tampala1136613tampala
tapa65129153tapa__
tapalos938813tapalos
tapas74627713tapa_s
tepal76319583tepal_
tepals85415043tepals
typal105311153typal_
unaptly1244793unaptly
vagal94613633vagal_
vasal85516293vasal_

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 Limit1127162085.51620434.4
3Display Results2082080.0633301.6
 (SQL Overall)1786912085.96929936.5
 
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.