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

132 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
pledgee1135963(None) 
pledge10469491pledg_e
pledged12358631pledged
pledgees12376281pledgees
pledger11359171pledger
pledges113811581pledges
pledget113510651pledget
fledge11439312fledg_e
fledged13417862fledged
fledges12409392fledges
ledge76519492_ledg_e
ledger85914392_ledger
ledges84918012_ledges
pledgeor12303462pledgeor
pledgers12387642pledgers
pledgets12365672pledgets
pledgor11334992pledgor
sledge85011302sledg_e
sledged103610332sledged
sledges94511572sledges
bludge104210973bludg_e
bludged12439313bludged
bludger11419563bludger
bludges114511123bludges
dredge9308563dredg_e
dredged11346893dredged
dredger10347453dredger
dredges10379353dredges
edge65719683__edg_e
edged85514533__edged
edger75215953__edger
edges75718743__edges
electee92513243electee
fledgier1333683fledgier
fledgy14414913fledg_y
glede75517833gled__e
gledes84915133gled_es
hedge105317353_hedg_e
hedged125211813_hedged
hedger114912653_hedger
hedges115016263_hedges
impledge1442973impledg_e
impledged1642693impledged
impledges1543153impledges
kedge115513733_kedg_e
kedged13439753_kedged
kedges124812983_kedges
kleagle1242933kleagle
kludge12407773kludg_e
kludged14366553kludged
kludges13397703kludges
kludgey16384653kludgey
league758743_league
ledgers94912183_ledgers
ledgier9458503_ledgier
ledgy105712023_ledg_y
leger65721513_le_ger
leges64427293_le_ges
legged95713093_legged
lessee64116363_lessee
levee84023813_le_vee
lodge76520093_lodg_e
lodged913815713_lodged
lodger86517693_lodger
lodges86820153_lodges
lungee75119813_lungee
mergee94018143_mergee
paleogene1245233paleogene
pardee93922023pard_ee
peage84723573p_eag_e
peages94321853p_eages
pedate93117763p_edate
peddle103512823p_eddle
pedes85327293p_ed_es
pedigree1244883p_edigree
pedler93614623p_edler
peewee11311963p_eewee
pegged114811913p_egged
pelage9515363pelag_e
pelages10714613pelages
pensee8417313p_ensee
perigee101113393perigee
pewee10319973p_e_wee
plage84520403pl_ag_e
plages94520153pl_ages
plague93610853pl_ague
pleaded113511263pleaded
pleader103511753pleader
please84315733ple_ase
pleased103712073pleased
pleaser93912343pleaser
pleases94515483pleases
pleated103816633pleated
pleater93916333pleater
plebe95014873ple__be
plebes104313623ple_bes
pled75231433pled___
pledgeors13313083pledgeors
pledging13276363pledging
pledgors12325263pledgors
pleurae945863pleurae
plexes155313543ple_xes
plodded1265563plodded
plodder1146003plodder
plugged12408043plugged
plugger11378433plugger
plunge93811053plung_e
plunged11439523plunged
plunger104211243plunger
plunges104011613plunges
pongee94920193p_ongee
preaged11612333preaged
predate10616893predate
predive13511083predive
repledge1243773repledg_e
repledged1443633repledged
repledges1343783repledges
sedge75019973_sedg_e
sedges83817813_sedges
sledded10378873sledded
sledder9399203sledder
sludge84811943sludg_e
sludged103610343sludged
sludges93811993sludges
splodge1134103splodg_e
splodged1333273splodged
splodges1234153splodges
unpledged1443843unpledged
wedge105215663_wedg_e
wedged125110303_wedged
wedges114614583_wedges
wedgie11428373_wedgie

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.393454684.5
2DLD Change Limit1340271326.76319817.7
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.20224811.3
 
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.