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

234 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
pedalos1032970(None) 
pedalo93811151pedalo_
pedals94316031pedal_s
medals94218062medal_s
peals75235492pe_al_s
pedagog12113762pedagog
pedagogs13123792pedagogs
pedal86022502pedal__
pedaled113711892pedaled
pedaler103410692pedaler
pedalers11239392pedalers
pedants10310112pedants
peddles112913702peddles
pedlars103210212pedlars
pedros9312182ped_ros
peplos101211542pe_plos
petalous1058972petalous
petals84719812petal_s
petasos948602petasos
aediles83413903aediles
apetalous1144583apetalous
beadles103414733beadles
beanos85516513be_anos
becalms1335743becalms
bedamns1235733bedamns
bedaubs1233693bedaubs
bedells10379363bedells
bedels94015273bedel_s
bedlams1237053bedlams
beefalos1343653beefalos
befalls12349123befalls
begalls10319163begalls
calos74431903__calos
catalos9414163catalos
cedars93312833ceda_rs
cedulas1058503cedulas
cellos84517803ce_llos
cembalos14135163cembalos
dados75522433__dados
dagos76419443__dagos
dales66439743__dales
dals57145123__dal_s
datos65222783__datos
deals65435343de_al_s
decalog1136003decalog
decalogs1245633decalogs
decals93717713decal_s
dedal75719023dedal__
dedans85915073deda_ns
desalts839573desalts
ediles74016983_ediles
enhalos1087533enhalos
etalon648973_etalon
etalons739073_etalons
exalts13328313_exalts
females12310663females
ferals94216643feral_s
gelatos83111523gelatos
halos85230253__halos
heals85733463he_al_s
heddles123311623heddles
hellos95321683he_llos
helos84928063he__los
heralds1137713heralds
hidalgos1342203hidalgos
ideals75012503ideal_s
jealous1438093je_alous
jellos134714283je_llos
legals73412733legal_s
legatos82711183legatos
meals75933383me_al_s
medakas1435763medakas
medal86221333medal__
medaled113411613medaled
medalist11414213medalist
meddles113213253meddles
medials103914743medial_s
medicos12339833medicos
medlars10259443medlars
megalops1356123megalops
metals84520893metal_s
modals93914463modal_s
padauks1443943padauks
paddles113515643paddles
padles95221123pad_les
paesanos10296703paesanos
pales75753803p__ales
palls74332563p__alls
palms94921753p__alms
palps94719563p__alps
pals66951353p__al_s
parados103816053parados
paramos113213513paramos
peaces106324083pe_aces
peages94321853pe_ages
peags86122843pe_a_gs
peaks114825623pe_a_ks
peal68648103pe_al__
pealed95322813pe_aled
peans75437643pe_a_ns
pearls84715393pe_arls
pears75138613pe_a_rs
peas65755063pe_a__s
peases85229473pe_ases
peats76140193pe_a_ts
pebbles1337573pebbles
pecans101515833peca_ns
pedagogy16122793pedagogy
pedalfer1443273pedalfer
pedalfers1542903pedalfers
pedalier1137603pedalier
pedaliers1245183pedaliers
pedaling122412133pedaling
pedalled1246933pedalled
pedaller1136093pedaller
pedallers1244763pedallers
pedant9319493peda_nt
pedate93117763peda_te
peddle103512823peddl_e
peddled123410543peddled
peddler113210493peddler
peddlers12298533peddlers
pedes85327293ped__es
pedicles1338683pedicles
pedipalps1342133pedipalps
pedlar93311273ped_lar
pedlary13277543pedlary
pedler93614623ped_ler
pedlers103013273pedlers
pedocals1346083pedocal_s
pedology15216903pedology
pedro8313153ped_ro_
peds75835243ped___s
peels75226423pe_el_s
pekans121710553peka_ns
pelages10714613pelages
peles75738083pe__les
pelfs105016293pe__lfs
pelon74423213pe__lon
pelts76128813pe__lts
penal75228373penal__
penalise101013763penalise
penally121111773penally
penalty1267743penalty
penangs10268373penangs
penates93321603penates
pendants1139093pendants
pendulous1243863pendulous
pengos94612413pe_ngos
penults937123penults
peoples11312223peoples
pepinos1137693pepinos
peplus10138343pe_plus
pepos96620083pe__pos
peptalks1653843peptalks
percales12313803percales
perilous10310693perilous
perils84121853peril_s
persalts1038193persalts
pesades10310903pesades
pesos77221623pe__sos
pestles93217693pestles
pestos84719083pe_stos
petal76526893petal__
petaled103614153petaled
petalody1443873petalody
petaloid1148753petaloid
petards104311153petards
petasus946363petasus
petrales10312983petrales
petrols92913083petrols
pettles93916483pettles
pharos11312063p_haros
phials1158873phial_s
phyllos1535583phyllos
pianos84315933p_ianos
pibals103813083pibal_s
picaros11310893picaros
piddles114314273piddles
piebalds1344343piebalds
pipals104213643pipal_s
podsols1056513podsols
podzols1934683podzols
polos76129913p__olos
pomelos11218133pomelos
praos74923563p_ra_os
predates11615813predates
predator11310053predator
predators12310083predators
predawns1444363predawns
presales10315263presales
psalms1045673p_salms
puddles113613823puddles
pueblos1134843pueblos
pumelos11196093pumelos
reales64934123re_ales
realms84913493re_alms
reals55038653re_al_s
rebatos92913113rebatos
recalls92613623recalls
redacts10510943redacts
redans75421023reda_ns
redates83423873redates
reddles93315773reddles
redials84416883redial_s
redos65126763red__os
refalls103312243refalls
regales83520793regales
resales74724903resales
robalos937683robalos
seals54839703se_al_s
secalose1046963secalose
sedans74816093seda_ns
sedates83418043sedates
sedulous946133sedulous
sendals81912273sendal_s
sepalous1047523sepalous
sepals85217383sepal_s
tapalos938813tapalos
teals56234133te_al_s
telos55424523te__los
tepals85415043tepal_s
veals84926193ve_al_s
vedalia1145683vedalia
vedalias1245153vedalias
wealds10459103we_alds
weals85428743we_al_s
wedelns11325243wedelns
wedels103811033wedel_s
zealot15313473ze_alot
zealots1636763ze_alots
zealous1637813ze_alous
zeals145320853ze_al_s
zocalos1835393zocalos

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272347.03319056.9
3Display Results2342340.0763078.9
 (SQL Overall)1786912347.51523777.9
 
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.