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

384 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
ladrons8381319(None) 
hadrons113314301hadrons
ladron73413321ladron_
ladrone83611871ladrone
ladrones92710971ladrones
lardons83914491lardons
adorns74212612_adorns
aldrins8310202aldrins
aprons8316992_aprons
barons85025382ba_rons
baudrons1135762baudrons
caldrons1138062caldrons
cardons104519932cardons
dacrons103211032dacrons
gadroons1037012gadroons
garrons82713462garrons
hadron102913752hadron_
ladens74516232lad_ens
ladinos8389962ladinos
lagoons839252lagoons
lardon74415062lardon_
lardoons9398482lardoons
macrons113514892macrons
madrona10288702madrona
madronas11288492madronas
madrone102812662madrone
madrones112912282madrones
madrono10288742madrono
madronos11337542madronos
marrons93216972marrons
matrons93517632matrons
natrons73215662natrons
padrone102512072padrone
padrones112711042padrones
padroni10278612padroni
pardons103817622pardons
patrons93818102patrons
radons74118532rad_ons
sadirons936022sadirons
acorns85013013_acorns
across8312643_across
adios65822863_adio_s
adjoins1585983_adjoins
adnouns835453_adnouns
adonis7314063_ad_onis
adores74420713_adores
adorn64917093_adorn_
ados57633513_ad_o_s
adroit7518793_adroit
aeons57624653_a_eons
agons66423783_a_gons
airns55521033_air_ns
alations82518893alations
aldols7109713ald_ols
aldrin7311243aldrin_
aleurons867003aleurons
andirons948423andirons
andros7313303andro_s
anions64123033_anions
anyons94513503_anyons
apron7318833_apron_
ardors74416873_ardors
argons75018203_argons
arrows92813483_arrows
arsons63917213_arsons
aurous64119263_aurous
avions94114393_avions
axions134713483_axions
axons125517933_a_xons
azlons154110423_azlons
azons146518253_a_zons
baboons113211073baboons
bacons104917583ba_cons
bairns86710873bair_ns
ballons93916963ballons
barns76335143ba_r_ns
baron78131243ba_ron_
barong96015823ba_rong
barongs105310833ba_rongs
barony115915303ba_rony
barrens94414323barrens
barrows123411683barrows
baryons121010473baryons
basions94213953basions
batons85519423ba_tons
bicrons113410473bicrons
blazons1836163bla_zons
borons85520543_borons
bradoons1136763bradoons
cadres94017933cadr_es
cairns85313303cair_ns
caldron1038153caldron_
camions113916133camions
cannons94412883cannons
canons85522063ca_nons
cantons95221203cantons
canyons124511593canyons
capons104119503ca_pons
carbons115418943carbons
cardon94120853cardon_
cardoons113411943cardoons
carns75937563ca_r_ns
carobs104818103ca_robs
carols85124983ca_rols
caroms105619573ca_roms
carrions10312453carrions
carroms11512403carroms
carrots9714623carrots
carryons1337103carryons
cartons94122473cartons
cations94524143cations
cauldrons1242973cauldrons
celadons1137003celad_ons
chaldrons1545493chaldrons
citrons92913223citrons
clarions10310493clarions
claroes93113733cla_roes
claros84015113cla_ro_s
classons1037703classons
claxons1635803cla_xons
codons96119463cod_ons
cordons104415763cordons
dacron94310693dacron_
dadoes85616533dad_oes
dados75522433dad_o_s
daemons10269233daemons
dahoons1137753dahoons
daikons12186693daikons
daimons10249323daimons
daltons8310403daltons
damsons1038013damsons
darns66927893da_r_ns
dendrons1047393dendrons
diatrons939613diatrons
diurons838823diurons
dons56048703__d_ons
drone65324983__drone
drones75023433__drones
drops85719503__drops
dross65418093__dross
drowns105612333__drowns
eardrops1165303eardrops
earns55927563ea_r_ns
elations83719123elations
endrins8312163endrins
fadeins1168503fadeins
fados95620733fad_o_s
falcons1239123falcons
fanions103713073fanions
fanons96115213fa_nons
faros85532023fa_ro_s
farrows13259783farrows
flacons1238053fla_cons
flagons1137973fla_gons
flaperons14125043flaperons
flatirons1244483flatirons
fleurons1155343fleurons
frons86124043__frons
gabions102410053gabions
gaboons10289893gaboons
gadroon938173gadroon
gallons83015953gallons
gammons1237973gammons
garcons102411643garcons
gardens93312093gardens
garron73113493garron_
gascons10289103gascons
girons75014373_girons
glabrous1145533glabrous
gladdens11364463gladdens
godroons1045363godroons
godsons966663godsons
gyrons105511223_gyrons
hadronic1447953hadronic
hagdons1258523hagdons
halons95720713ha_lons
hardens113815023hardens
harrows132611033harrows
herons94820543_herons
hydrops16197413hydrops
hydros13279363hydro_s
hydrous14197883hydrous
introns73515023introns
irons55324133__irons
jargons1558203jargons
kaons95014853ka__ons
karns96624143ka_r_ns
karoos102415803ka_roos
kaross101910013ka_ross
karroos1139313karroos
kations114013663kations
klaxons1833263kla_xons
labors84016413la_bors
labrets939363labrets
labroid1038823labroid
labroids1155843labroids
labrums1175853labrums
lacrosse1044113lacrosse
lactone9311393lactone
lactones10311223lactones
ladders94115173ladders
laddies93715053laddies
laden65022193lad_en_
laders74927763lad_ers
lades65141273lad__es
ladhood1246473ladhood
ladhoods1345873ladhoods
ladies75124883lad_ies
lading84227123lad_ing
ladings93814133ladings
ladino73615123lad_ino
ladlers84613563ladlers
ladles74619543lad_les
ladling92813393ladling
lads56549133lad___s
ladykins1643603ladykins
lagans75717783la_gans
lagoon7410483lagoon_
lairds74711613lair_ds
lairing83715343lairing
lairs55425873lair__s
lallans74113533lallans
lampions12277973lampions
lampoons12266863lampoons
lapdogs1134073lapdogs
lapins84520683la_pins
laptops1166603laptops
larders83516943larders
larding92917873larding
lardoon83410373lardoon
lards65331863la_r_ds
larees65323113la_rees
lares54852633la_r_es
larges74824233la_rges
largos74815063la_rgos
larine63927043la_rine
laris54737463la_r_is
larks95227813la_r_ks
larrups934733larrups
lars46956573la_r__s
larums83610533la_rums
larvas9310233la_rvas
larynx1632853la_rynx
lashins103915153lashins
lassoes74613853lassoes
lassos64913813lasso_s
lateens74210553lateens
latens64620213la_tens
latinos73613803latinos
latrias71913213latrias
latrine7715123latrine
latrines8515003latrines
lattens75014673lattens
lattins74115483lattins
lauans65113533la_uans
lauras63414333laur_as
laurels746663laurels
lavrock1644223lavrock
lavrocks1743663lavrocks
lawns85215423la__wns
layins93817653la_yins
leadens83610983lead_ens
learns65513743lear_ns
legions84611783legions
lemons84415053l_emons
leprous938843leprous
leptons91910413leptons
lesions73813863lesions
lessons73811013lessons
leukons1135753leukons
liaisons844293liaisons
lidos65219883lid_o_s
ligroins946823ligroins
linurons846333linurons
lions55923213l__ions
lodens74315063lod_ens
logions86211293logions
logons79818173l_ogons
loons55731723l__oons
lorans65117603l_orans
lotions74614763lotions
lurdans837073lurdans
macons104017243ma_cons
macron103615673macron_
macros104017013macro_s
maddens11359753maddens
madras94316433madr_as
madres93718183madr_es
madtoms1236923madtoms
maduros1036303maduro_s
madzoons20124773madzoons
mammons1048513mammons
maroons92615553maroons
marron83717543marron_
marrows122911813marrows
mascons113411583mascons
masons83916513ma_sons
matron83918313matron_
microns113814783microns
midirons1145883midirons
mikrons13428413mikrons
morons84919543_morons
narrows10258843narrows
nasions73112383nasions
nations74720563nations
natron64116023natron_
neurons7410443neurons
odeons739023_odeons
operons91411743operons
padres95016983padr_es
padronism1445493padronism
paeons83915523pa_eons
pardon94618733pardon_
parols84722613pa_rols
parous84024163pa_rous
parrots9312743parrots
parsons93516873parsons
partons94620513partons
patrols93513513patrols
patron84018043patron_
patroons102710603patroons
pauldrons1242523pauldrons
pedros9312183pedro_s
perrons93115483perrons
plasmons12217663plasmons
plastrons1147133plastrons
platoons1038683platoons
polarons1039863pola_rons
quadrans1866363quadrans
quadroons1944183quadroons
racons84319343ra_cons
racoons93912433racoons
radians83013823radians
radios74018673radio_s
radon64620503rad_on_
ramrods1036583ramrods
ramsons939563ramsons
rations74123433rations
ratoons73815473ratoons
rattons73815323rattons
rayons94113343ra_yons
readorns938283readorns
redons75222183red_ons
saddens9309603saddens
sadiron836043sadiron_
saffrons1444303saffrons
safrols1036863safrols
salmons93713263salmons
salons63823693sa_lons
saloons74415313saloons
sarans64224433sa_rans
sarins63932623sa_rins
sarods74918573sa_rods
sarong73914873sa_rong
sarongs84511803sa_rongs
saros55238063sa_ro_s
squadrons1943253squadrons
talions7314103talions
talons64019433ta_lons
tampons112711553tampons
tardyons1244613tardyons
tarns56433953ta_r_ns
tarocs84615663ta_rocs
taroks106115283ta_roks
taros55640823ta_ro_s
tarots66422993ta_rots
tarpons92612203tarpons
tauons63412673ta_uons
taxons134211503ta_xons
thorons104511913thorons
udons65411463_ud_ons
wadmols1333913wadmols
waggons1235503waggons
wagons103911213wa_gons
waitrons1136633waitrons
wanions104011373wanions
wantons103713013wantons
wardens113711903wardens
warns87231003wa_r_ns
warrens103810893warrens
yapons114411773ya_pons
yarns85621793ya_r_ns
yarrows13277853yarrows
yaupons12345683yaupons

Search took 10 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.1601116818.8
2DLD Change Limit1340273848.90315054.1
3Display Results3843840.1432685.3
 (SQL Overall)1786913849.20619410.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.