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

307 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
pedalo9381114(None) 
pedal86022501pedal_
pedalos10329681pedalos
pedals94316031pedals
dedal75719022dedal_
medal86221322medal_
medals94218042medals
peal68648102pe_al_
peals75235492pe_als
pedagog12113762pedagog
pedaled113711872pedaled
pedaler103410692pedaler
pedant9319492pedant
pedate93117762pedate
peddle103512822peddle
pedlar93311272pedlar
pedro8313152ped_ro
penal75228372penal_
petal76526892petal_
petals84719812petals
aedile73716653aedile
apetaly1237253apetaly
apodal9289823apodal_
beadle93314683beadle
beano75421553be_ano
becalm1239203becalm
bedamn1137813bedamn
bedaub1146033bedaub
bedel84219393bedel_
bedell93610043bedell
bedels94015273bedels
bedlam1149273bedlam
beefalo1244083beefalo
befall114410643befall
begall92610723begall
behalf14310953behalf
bipedal1245683bipedal_
calo64936443__calo
catalo8314853catalo
cecal94619113cecal_
cedar84014323ceda_r
cedarn9408443cedarn
cedars93312833cedars
cedary12419603cedary
cedula977643cedula
cello74919583ce_llo
cembalo13145533cembalo
credal9311673credal_
dado67126333__dado
daedal849083daedal_
dago65725083__dago
dal47554953__dal_
dale55643983__dale
dals57145123__dals
dato56129943__dato
deadly113811473deadly
deal56347413de_al_
deals65435343de_als
dealt65234283de_alt
decal85523233decal_
decalog1136003decalog
decals93717713decals
dedans85915073dedans
desalt7518313desalt
eddo63411803_ed_do
edile64819493_edile
egal55119433_egal_
enhalo987563enhalo
etalon648973_etalon
exalt123018533_exalt
feal713940423fe_al_
fecal105119213fecal_
female11310553female
feral85424653feral_
ferals94216643ferals
fetal85623373fetal_
feudal1037683feudal_
gelato73812953gelato
hadal95518123hadal_
halo76437323__halo
heal75645693he_al_
heals85733453he_als
heddle114211163heddle
hello86522983he_llo
helo75332853he__lo
hemal104419803hemal_
herald10311343herald
hidalgo1242373hidalgo
ideal65716393ideal_
ideals75012503ideals
jello126716273je_llo
leal46043273le_al_
legal65715943legal_
legals73412733legals
legato72810953legato
meal65643173me_al_
meals75933373me_als
mealy104422183me_aly
medaka1336343medaka
medaled113411603medaled
meddle103312763meddle
medfly1535223medfly
medial93819863medial_
medials103914733medials
medico113711163medico
medlar93010463medlar
metal75427383metal_
metals84520883metals
modal85919233modal_
modals93914443modals
modulo9256973modulo
nidal65217103nidal_
nodal64717793nodal_
padauk1335643padauk
paddle104615143paddle
padle84522343pad_le
paesano9338793paesano
pal56761673p__al_
pale66055013p__ale
pall65039343p__all
palm85331363p__alm
palp85828573p__alp
pals66951353p__als
paly95835533p__aly
papal95820673papal_
paramo102614643paramo
pea56657243pe_a__
peace95026083pe_ace
peach125422493pe_ach
peag75431343pe_a_g
peage84723563pe_age
peags86122843pe_ags
peak106535203pe_a_k
peaks114825623pe_aks
peaky145718153pe_aky
pealed95322803pe_aled
pean66147173pe_a_n
peans75437643pe_ans
pear69745233pe_a_r
pearl75324463pe_arl
pearls84715383pearls
pearly116414843pearly
pears75138613pe_ars
peart76440753pe_art
peas65755063pe_a_s
pease75231113pe_ase
peat65967933pe_a_t
peats76140193pe_ats
peaty105725693pe_aty
peavy135014843pe_avy
pebble1238003pebble
pebbly1545083pebbly
pecan91919033peca_n
pecans101515833pecans
ped66751523ped___
pedagogs13123793pedagogs
pedagogy16122793pedagogy
pedalers11239393pedalers
pedalfer1443273pedalfer
pedalier1137603pedalier
pedaling122412133pedaling
pedalled1246903pedalled
pedaller1136083pedaller
pedants10310113pedants
pedately1445423pedately
peddled123410533peddled
peddler113210493peddler
peddles112913693peddles
pedes85327283ped_es
pedicle1238963pedicle
pedipalp1242513pedipalp
pedlars103210213pedlars
pedlary13277543pedlary
pedler93614613pedler
pedocal1237893pedocal_
pedocals1346083pedocals
pedology15216903pedology
pedros9312183pedros
peds75835243ped__s
peel65535613pe_el_
peels75226423pe_els
pekan111613973peka_n
pekans121710553pekans
pelage9515363pelage
pele65539553pe__le
pelf97031453pe__lf
pelon74423213pe__lon
pelt67651083pe__lt
penally121111763penally
penalty1267743penalty
penang92511113penang
pendant10314853pendant
pengo84317593pe_ngo
penial84120893penial_
penile82219603penile
penult8314653penult
people10310183people
pepino10310333pepino
pepla9312863pe_pla
peplos101211543pe_plos
pepo87622153pe__po
peptalk1554823peptalk
percale11314083percale
peril75425953peril_
perils84121853perils
pernio8513143pernio
persalt9315413persalt
pertly115312543pertly
pesade9311103pesade
peso66925823pe__so
pestle83215843pestle
pesto75723723pe_sto
petaled103614143petaled
petalody1443863petalody
petaloid1148733petaloid
petalous1058963petalous
petard95013803petard
petasos948603petasos
petrale9312623petrale
petrol82714063petrol
pettle84116053pettle
petto76021043pe_tto
phial10313203phial_
phials1158873phials
phyllo1435873phyllo
pial65636703p_ial_
piano76118713p_iano
pibal95217323pibal_
pibals103813083pibals
pical95524373pical_
picaro10311323picaro
piddle103514913piddle
piddly13319143piddly
piebald1245503piebald
pipal95118353pipal_
pipals104213643pipals
plexal1536833plexal_
podsol946853podsol
podzol1835083podzol
polo66236633p__olo
pomelo10238663pomelo
potato8513433potato
prao66229023p_ra_o
predate10616893predate
predator11310053predator
predawn1335353predawn
predial103815413predial_
presale9416353presale
psalm949273p_salm
puddle103914153puddle
puddly13438133puddly
pueblo1035553pueblo
pumelo10257113pumelo
pupal97616873pupal_
real45750293re_al_
realm75621623re_alm
reals55038653re_als
rebato83714683rebato
recall83815723recall
redact9419043redact
redan66125013reda_n
redans75421023redans
redate74124683redate
reddle83815913reddle
redial74923113redial_
redials84416883redials
redly94217193red_ly
redo56029363red__o
refall94314393refall
regal65023793regal_
regale74821453regale
renal55929503renal_
resale64025543resale
robalo838923robalo
seal45654373se_al_
seals54839693se_als
sedan65620423seda_n
sedans74816093sedans
sedate73019803sedate
sedile73517233sedile
sendal73314993sendal_
sendals81912263sendals
sepal77723003sepal_
sepals85217373sepals
seral56336383seral_
setal56430903setal_
tapalo839793tapalo
teal45546503te_al_
teals56234133te_als
tepal76319583tepal_
tepals85415043tepals
tidal64516443tidal_
veal76936813ve_al_
veals84926193ve_als
vealy115817773ve_aly
vedalia1145673vedalia
venal85523213venal_
weal75838683we_al_
weald95615023we_ald
weals85428743we_als
wedel94513953wedel_
wedeln10326693wedeln
wedels103811033wedels
zeal135530333ze_al_
zealot15313473ze_alot
zeals145320853ze_als
zocalo1735803zocalo

Search took 7 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.1401276364.3
2DLD Change Limit1127163076.15618309.9
3Display Results3073070.1102790.9
 (SQL Overall)1786913076.40627894.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.