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

117 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
panda8502261(None) 
banda85223101banda
panada94113051panada
pandas95521961pandas
pandy115021171pandy
panga85323531panga
vanda94515921vanda
ana39559832_an_a
and47244172_and_
ands57833612_ands
anga56831352_anga
anna45529012_anna
anoa45634472_anoa
ansa45927772_ansa
anta46839582_anta
apnea73413412apnea
band76740912band_
bandas95120542bandas
bands85233422bands
bandy114824182bandy
candy115119822candy
canna75919332canna
dada66422442da_da
dandy104416702dandy
fanga96119622fanga
ganja131410002ganja
garda7316762garda
hand86833712hand_
handax1749582handax
hands95327382hands
handy125520872handy
hansa85416782hansa
honda9414982honda
kana85928532kan_a
land56337312land_
landau7310612landau
lands65426902lands
mana65341962man_a
manga85026202manga
mania75634152mania
manna75522542manna
manta75629912manta
nada58022902na_da
nana46632902nan_a
paca85132242pa_ca
pacha126518062pacha
pad68057322pa_d_
paddy125913592paddy
padi76331782pa_di
padnag1036072padnag
pads76742952pa_ds
pagoda10487872pagoda
paid75737482paid_
paisa76021072paisa
palea75028662palea
pampa114913422pampa
pan58466452pan__
panadas103312212panadas
panama104213352panama
pandani1039902pandani
pander93725522pander
pandit93820752pandit
pandora1039542pandora
pandura1037142pandura
pane64950292pan_e
paned85437182paned
panel76023622panel
panes76148692panes
pang75336292pan_g
pangas99921102pangas
pangs84628662pangs
panic93923902panic
panne76623652panne
pans65855732pan_s
pansy105717972pansy
pant66061262pan_t
panto76129412panto
pants76536922pants
panty105929302panty
papa85827142pa_pa
para65242172pa_ra
pard76441322pard_
pardah123412822pardah
pardi85723952pardi
pards85634332pards
pardy115523952pardy
parka115120882parka
pasha105417182pasha
pasta76624532pasta
payday1536612payday
pend75934532pend_
pends85527192pends
penna74520202penna
pina65842632pin_a
pinna75320182pinna
pinta75727052pinta
pond75530492pond_
ponds85323402ponds
puna65331652pun_a
punka114515482punka
purda82914692purda
rand55839572rand_
randan7315252randan
rands65930452rands
randy95022082randy
sand55338472sand_
sandal73317282sandal
sands65228582sands
sandy94221132sandy
sanga66023792sanga
tanga64923692tanga
tanka93817482tanka
vandal103713832vandal
vandas103915992vandas
wand85833882wand_
wands96425482wands
zanza1378702zanza

Search took 3 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.343520965.0
2DLD Change Limit538001171.73630990.8
3Display Results1171170.0303900.0
 (SQL Overall)1786911172.10984727.8
 
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.