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 “panel” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

178 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
panel7602362(None) 
pane64950291pane_
paned85437181paned
panels84716521panels
panes76148691panes
anal48037522_anal
ane37866952_ane_
anele55628832_anele
anes45255932_anes
anew76623132_anew
angel65019562_angel
anil46437432_anil
apnea73413412apnea
apneal83411122apneal
appel94615892appel
axel115222072_axel
babel95821692babel
bagel85116792bagel
banal75925992banal
bane65250432bane_
baned85436352baned
banes74945582banes
camel96822802camel
canal75428042canal
cancel105316682cancel
cane66653122cane_
caned85838092caned
caner75334772caner
canes75350372canes
cannel84216402cannel
darnel74312182darnel
dynel9569852dynel
easel54521112easel
empanel1145962empanel
fane75343572fane_
fanes84639892fanes
gane55145302gane_
ganef96322462ganef
ganev95513862ganev
gavel95815182gavel
hansel95214372hansel
hazel176414812hazel
impanel1137092impanel
jane115031482jane_
janes124928122janes
kane85133972kane_
kanes95529372kanes
label75019382label
lane45153332lane_
lanely93914482lanely
lanes54946792lanes
lapel73716682lapel
mane65052032mane_
maned86634102maned
manes76648962manes
mangel94017532mangel
mantel84317972mantel
navel87016572navel
pace86345772pace_
paced106931682paced
pacer96131612pacer
paces96741112paces
pacey126720282pacey
padle84522342padle
page76036102page_
paged95926782paged
pager84728202pager
pages85235072pages
pail66141832pa_il
pained95622852pained
pal56761672pa__l
pale66055012pale_
palea75028662palea
paleal84716672paleal
paled85538722paled
palely11311932palely
paler75436932paler
pales75753802pales
palet74650802palet
pall65039342pa_ll
pan58466452pan__
panda85022612panda
pander93725522pander
pandy115021172pandy
paneled10612572paneled
panful1179742panful
pang75336292pan_g
panga85323532panga
panged104722332panged
pangen94115912pangen
pangs84628662pangs
panic93923902panic
panier84425502panier
panne76623652panne
panned94123432panned
panner84224762panner
pannes85522852pannes
pans65855732pan_s
pansy105717972pansy
pant66061262pan_t
panted95024822panted
panto76129412panto
pants76536922pants
panty105929302panty
panzer174213232panzer
papal95820672papal
paper95128662paper
parcel103915472parcel
pare66760842pare_
pared86946762pared
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
parle75836162parle
parol74826272parol
parrel84515982parrel
pase65346862pase_
paseo77022512paseo
pases75346502pases
passel85117002passel
pastel85918712pastel
pate65350462pate_
pated85237842pated
paten74827342paten
pater74740722pater
pates76047892pates
pave96133892pave_
paved115525262paved
paver104225832paver
paves104833922paves
pawed115725612pawed
pawer104422972pawer
pawl95123262pa_wl
pawned124513282pawned
pawnee113115402pawnee
pawner114212922pawner
paxes144928422paxes
payed115925932payed
payee105524722payee
payer105125722payer
peel65535612p_eel
penal75228372penal
pencel103812912pencel
penes75839222penes
pine67755712pine_
pineal84817682pineal
pined85935322pined
pines76048862pines
piney105727502piney
pixel143911902pixel
plane74929142plane_
planed94420912planed
planer84122652planer
planes85028082planes
planet84228352planet
pone65747532pone_
pones74547042pones
ranee55438102ranee
ratel54224882ratel
ravel84621512ravel
repanel939962repanel
sane45954342sane_
saned65636272saned
sanely93114612sanely
saner54334322saner
sanes55649072sanes
spancel1147362spancel
spaniel948922spaniel
spinel85317332spinel
tael46030712ta_el
vane75534692vane_
vaned94622422vaned
vanes85130972vanes
wane76344722wane_
waned95831782waned
wanes85040882wanes
waney115120322waney

Search took 2 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 Filter178691538000.300595636.7
2DLD Change Limit538001781.43637465.2
3Display Results1781780.0463869.6
 (SQL Overall)1786911781.782100275.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.