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

207 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
padrones11271104(None) 
ladrones92710981ladrones
madrones112912281madrones
padrone102512071padrone_
drones75023432__drones
hadrons113314302hadron_s
ladrone83611882ladrone_
ladrons83813192ladron_s
madronas11288492madronas
madrone102812662madrone_
madronos11337542madronos
padres95016982padr__es
padroni10278612padron_i
padronism1445502padronism
pardoned12189332pardoned
pardoner11189442pardoner
pardoners12208222pardoners
pardons103817622pardon_s
paroles95025892pa_roles
patroness1137492patroness
patrons93818102patron_s
pyrones123113302p_yrones
spadones1137252spad_ones
adobes94411533_ad_obes
adonis7314063_ad_onis
adores74420723_ad_ores
adorned9256893_adorned
adorner8246983_adorner
adorners9196623_adorners
adorns74212613_adorn_s
aerobes9311493_aerobes
agones75719863_a_gones
amarones10311353amarones
ambones11312683_ambones
ancones93116343_ancones
approves15126833approves
aproned10311503_aproned
aprons8316993_apron_s
arenes64928393_a_renes
atones65225773_a_tones
axones134614513_a_xones
baroness101210063ba_roness
baronet91022213ba_ronet
baronets101410913ba_ronets
barongs105310833ba_rongs
baronies10315023ba_ronies
baronnes1038553ba_ronnes
barons85025383ba_ron_s
baudrons1135763baudron_s
baudronses1341983baudronses
cadres94017933cadr__es
cajones163311333ca_jones
caldrons1138063caldron_s
calzones1948763calzones
canzones1939153canzones
cardons104519943cardon_s
crones84729243__crones
dacrons103211033dacron_s
dadoes85616533dad_o_es
daemones11209163daemones
daimones11208803daimones
dapsones1138383dapsones
drone65324983__drone_
droned84616863__droned
droner74717673__droner
droners84114383__droners
droves105116673__droves
estrones8313333estrones
gadrooned1243403gadrooned
gadroons1037013gadroons
garotes8614573ga_rotes
garrons82713463garron_s
garrotes969383garrotes
hadron102913753hadron__
hadronic1447953hadronic
hambones1539673hambones
hidroses1237903hidroses
irones64724013__irones
jawbones20134853jawbones
lactones10311243lactones
ladron73413323ladron__
lardons83914493lardon_s
latrines8515013latrines
macrons113514893macron_s
madrases112610003madrases
madres93718183madr__es
madrona10288703madron_a
madrono10288743madron_o
manropes1237913manropes
marines93928033ma_rines
marrons93216973marron_s
matrons93517633matron_s
mucrones1237603mucrones
natrons73215663natron_s
neurones839683neurones
paddies113715723pad_dies
paddings13297013paddings
paddles113515643pad_dles
paddocks1894323paddocks
padles95221123pad__les
padlocks1755473padlocks
padouks1434873pad_ouks
padre86018163padr__e_
padronisms1544893padronisms
paeons83915523pa_eon_s
pairings11398313pairings
pandores11312453pandores
panes76148693pa___nes
pangenes112612833pangenes
pannes85522853pa__nnes
papooses1248053papooses
parades104121473pa_rades
parangs104314383pa_rangs
parches143720003pa_rches
pardine103616733pardine_
pardner10239473pa_rdner
pardners11269203pa_rdners
pardon94618733pardon__
parents93418133pa_rents
pares77164483pa_r__es
pareses94718883pa_reses
parges94529543pa_r_ges
paries84742523pa_r_ies
parings104219223pa_rings
parises94827193pa_rises
parles86334413pa_r_les
parodies11313693pa_rodies
parodos103011753pa_rodos
parole84425253pa_role_
paroled104217633pa_roled
parolee94119653pa_rolee
parolees104313993pa_rolees
parols84722613pa_ro_ls
paronym1437503pa_ronym
paronyms1546553pa_ronyms
parous84024163pa_ro_us
parries93925853pa_rries
parroket1449213parroket
parrokets1543923parrokets
parroted1158853parroted
parroter1058213parroter
parroters1156773parroters
parrots9312743parro_ts
parses85534703pa_r_ses
parsons93516873parson_s
parties93230873pa_rties
partner92811393pa_rtner
partners102711143pa_rtners
partons94620513parton_s
parures9512693pa_rures
pathoses13412773pathoses
patines95225773pa_tines
patrols93513513patro_ls
patron84018043patron__
patronages1374973patronages
patronal1048653patronal
patronise1198463patronise
patronises1298453patronises
patronizes2187413patronizes
patronly1344883patronly
patroons102710603patroons
pauldrons1242523pauldron_s
pavanes123612663pa_vanes
payrolls1344753payrolls
pedros9312183pedro__s
peones83821043p__eones
peptones12311033peptones
perrons93115483perron_s
petronel1048143petronel
petronels1146063petronels
pharoses13310323pharoses
phones114121213p__hones
pinbones1238143pinbones
pinones94717073p_inones
pones74547043p___ones
probes104119453p__robes
prodromes1446063prodromes
proles84627203p__roles
prone75332623p__rone_
prongs94314483p__rongs
propones122516963propones
proses84733473p__roses
proves114322253p__roves
prunes83419063p__runes
purines94420773p_urines
pyrenes123511223p_yrenes
pyrone112714473p_yrone_
pyropes142210193p_yropes
pyrroles1345453pyrroles
radomes10311053rad_omes
radons74118533rad_on_s
redbones1137593redbones
sadirons936033sadiron_s
safroles1136933safroles
saprobes1237033saprobes
sardines92815583sardines
sarodes84216143sa_rodes
sarongs84511803sa_rongs
saroses73619333sa_roses
sawbones13126643sawbones
seadromes1246103seadromes
tacrines10310563tacrines
tadpoles1135953tadpoles
taurines8310553taurines
thrones105715843_thrones
trones65629283__trones
wardrobes1583803wardrobes

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622076.58022213.1
3Display Results2072070.0932225.8
 (SQL Overall)1786912077.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.