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

287 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
pledging1327636(None) 
fledging14276521fledging
sledging11288181sledging
bludging13297462bludging
dredging12236422dredging
edging93510712__edging
fledgling1552472fledgling
hedging13348952_hedging
impledging1742172impledging
kedging14357552_kedging
kludging15264512kludging
legging103912642_legging
lodging103110812_lodging
pegging122811132p_egging
pleading123011442pleading
pleasing112611592pleasing
pleating112916052pleating
plodding13166342plodding
plugging13306892plugging
plunging12357672plunging
repledging1543622repledging
sledding11248502sledding
sludging11268362sludging
splodging1433302splodging
wedging13308722_wedging
abegging1334483abegging
alerting91312383alerting
alleging1038473alleging
avenging1345863avenging
badging123712793_badging
bedding124114483_bedding
begging123012653_begging
blading113615363blad_ing
blagging13319163blagging
blearing113111943blearing
bleating113514503bleating
blebbing12265673blebbing
bleeding12359053bleeding
bleeping13377933bleeping
blending12249963blending
blessing1137593blessing
blogging13369013blogging
blunging12328413blunging
bridging13288443bridging
budging124313023_budging
cadging123610973_cadging
ceding104014803_ced_ing
cladding1337143cladding
clagging13328873clagging
clanging124012123clanging
cleaning113112383cleaning
clearing113014883clearing
cleating113518133cleating
cleaving141389683cleaving
cleeking15267813cleeking
clefting14347583clefting
cleping123310423cle_ping
clerking15257163clerking
clewing13359583cle_wing
clinging122910913clinging
clogging13368503clogging
deeding103315123deed_ing
deluging1137123deluging
dodging11299063_dodging
dredgings13252953dredgings
drudging12256233drudging
edgings10256243__edgings
egging93210983__egging
electing112113783electing
eliding93414343elid_ing
eluding93412113elud_ing
emerging1237893emerging
fadging134210243_fadging
feeding123515073feed_ing
fidging133910503_fidging
flagging14329223flagging
flanging132710583flanging
flecking18408233flecking
fledgier1333683fledgier
fledglings1641093fledglings
fleecing14347573fleecing
fleeing113511293fle_eing
fleering123811283fleering
fleeting122910323fleeting
flensing1246973flensing
fleshing15339303fleshing
flexing18358993fle_xing
fleying14329873fle_ying
flinging133310053flinging
flogging14329173flogging
fudging133310013_fudging
gelding103911793geld_ing
gladding1236303gladding
gleaming12277933gleaming
gleaning10269323gleaning
gleeking14316493gleeking
gleeting10279173gleeting
gleying12318433gle_ying
gliding103911843glid_ing
glugging10316353glugging
grudging12255993grudging
heeding123515063heed_ing
judging17337933_judging
kegging14328293_kegging
kluging13356593kl_uging
lading84227123_lad_ing
ladling92813393_ladling
lagging103316733_lagging
leading93419553_leading
leafing113313583_leafing
leaguing1035343_leaguing
leaking123616973_leaking
leaning83721203_leaning
leaping103215993_leaping
leasing83920163_leasing
leaving114216853_leaving
leching134613653_leching
ledgier9458493_ledgier
leering83417643_leering
leggin8268593_leggin_
leggings11316193_leggings
leggins9259473_leggins
legong836963_le_gong
lekking11306503_lekking
lemming12269393_lemming
lending94118533_lending
lensing84015103_lensing
letting83218533_letting
levying1435873_levying
lidding103611433_lidding
lodgings11336243_lodgings
logging103316803_logging
longing93915783_longing
lugging104114353_lugging
luging83915293_l_uging
lunging93714213_lunging
melding113414273meld_ing
merging112711763_merging
needing93214423need_ing
needling10248753needling
noodging11185693noodging
nudging10328693_nudging
padding123412513p_adding
paddling13218643paddling
paging104020403p__aging
pandying15217663pandying
panging113319113p_anging
parging113318603p_arging
peacing124117073p_eacing
peaking144317693p_eaking
pealing104123203p_ealing
peching154513903p_eching
pecking164017783p_ecking
pedaling122412133p_edaling
peddling13217973peddling
peeing94618083p_e_eing
peeking144414953p_eeking
peeling102919873p_eeling
peening103318303p_eening
peeping123615213p_eeping
peering103520353p_eering
peeving135112243p_eeving
peining104619153p_eining
peising103416763p_eising
pelting102917273p_elting
pending114119773p_ending
penning103616493p_enning
pepping113511623p_epping
perking143716463p_erking
perming123416093p_erming
petting103720953p_etting
piddling13208953piddling
pidgin10259813p_idgin_
pidgins11259123p_idgins
piecing12410453pie_cing
pieing93917653pie__ing
piercing1346663piercing
pigging123614673p_igging
pillaging1345553pillaging
pindling122110983pindling
pinging113419553p_inging
placing123815283pl_acing
plaguing1236033plaguing
plaining113911553plaining
plaiting113113513plaiting
planing103418253pl_aning
planking153513013planking
planning113610223planning
planting113515383planting
plashing143311063plashing
plating103823073pl_ating
platting114813033platting
playgoing1663563playgoing
playing133816093pl_aying
pleaching17257083pleaching
pleadings13285543pleadings
pledge10469473pledg__e
pledged12358613pledg_ed
pledgee11359613pledg_ee
pledgees12376273pledgees
pledgeor12303463pledgeor
pledger11359153pledg_er
pledgers12387643pledgers
pledges113811563pledg_es
pledget113510633pledg_et
pledgets12365673pledgets
pledgor11334993pledg_or
pledgors12325263pledgors
plinking153611243plinking
plonking15358563plonking
plopping12318703plopping
plotting113011013plotting
plotzing20276143plotzing
ploughing16203673ploughing
plowing133111723pl_owing
ploying132811573pl_oying
plucking17357723plucking
plumbing15286433plumbing
pluming123412043pl_uming
plumping15277633plumping
plunking15328483plunking
plying124312083pl__ying
podding124113183p_odding
poleaxing1944873poleaxing
ponding114317083pond_ing
ponging113416153p_onging
pranging123012723pranging
predating13514653predating
predrying1645343predrying
preeing103817673pre_eing
preening113115843preening
prejudging2242803prejudging
prepping12309763prepping
presaging1339393presaging
pressing112516443pressing
prevuing1457253prevuing
preying133114553pre_ying
priding113317543prid_ing
prigging13299093prigging
prodding13189343prodding
progging132610383progging
pronging123511843pronging
pudding124010803p_udding
puddling13218033puddling
pugging122912543p_ugging
purging113314183p_urging
redding103218513_redding
reding83825563_red_ing
redoing93516733_redoing
redwing122811983_redwing
reeding94124133reed_ing
reedling102414273reedling
ridging104112983_ridging
seeding93719483seed_ing
seedling102610953seedling
serging93416673_serging
shedding14278113shedding
sieging92613203sie_ging
slagging113711573slagging
slanging103413433slanging
sleaving123310983sleaving
sleddings12263783sleddings
sleeking133410963sleeking
sleeping113812053sleeping
sleeting93114163sleeting
sleeving12359283sleeving
sleighing1434213sleighing
slewing113311353sle_wing
sliding93114553slid_ing
slinging103312863slinging
slogging113410493slogging
slugging11339423slugging
smudging13255723smudging
snedding11246953snedding
speeding122810933speed_ing
splurging1333623splurging
stodging11277463stodging
sueding92613753sued_ing
tedding103210883_tedding
trudging11266443trudging
upleaping1434363upleaping
vegging13308873_vegging
venging123710943_venging
verging123812303_verging
wedding133411873_wedding
weeding123815213weed_ing
welding123213253weld_ing

Search took 9 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.1701051123.5
2DLD Change Limit1461622877.76618820.8
3Display Results2872870.1102609.1
 (SQL Overall)1786912878.04622208.7
 
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.