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 “pledgors” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

62 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
pledgors1232526(None) 
pledgeors13313081pledgeors
pledgers12387641pledgers
pledgor11334991pledgor_
ledgers94912182_ledgers
pledgees12376282pledgees
pledgeor12303462pledgeor_
pledger11359172pledger_
pledges113811582pledg_es
pledgets12365672pledgets
plessors10278252plessors
plexors1645422ple_xors
alegars838933ale_gars
algors7312553al__gors
bludgers12397853bludgers
clangors11417003clangors
dredgers11256093dredgers
edgers84413923__edgers
electors103013853electors
fledges12409393fledg_es
flexors1734773fle_xors
hedgers124310263_hedgers
lectors93415773_lectors
ledger85914393_ledger_
ledges84918013_ledg_es
legers74518313_le_gers
lessors73610523_lessors
lodgers95113833_lodgers
pandoors11258983pandoors
pedagogs13123793p_edagogs
pedlars103210213p_edlars
pedlers103013273p_edlers
pedros9312183p_edro_s
pengos94612413p_engo_s
piedfort1444873piedfort
piedforts1542483piedforts
playgoers1543193playgoers
pleaders113210183pleaders
pleasers104010293pleasers
pleaters103613793pleaters
pledge10469493pledg__e
pledged12358633pledg_ed
pledgee11359633pledg_ee
pledget113510653pledg_et
pledging13276363pledging
pleons84213343ple__ons
pleopods1344443pleopods
plessor9317693plessor_
plethora1344823plethora
plethoras1444803plethoras
plexor1535253ple_xor_
plodders1235523plodders
pluggers12297023pluggers
plungers11379403plungers
predators12310083predators
preggers12236833preggers
pressors103212693pressors
pretors9316813pre_tors
sledders10257373sledders
sledges94511573sledg_es
splendors1244023splendors
weldors11238003weld_ors

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 Filter1786911461620.440406115.9
2DLD Change Limit146162626.40622816.4
3Display Results62620.0134769.2
 (SQL Overall)178691626.85926052.0
 
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.