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

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

61 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
pleader10351175(None) 
leader74824651_leader
pleaded113511261pleaded
pleaders113210181pleaders
pleaser93912341pleaser
pleater93916331pleater
beader94623792_beader
blader93618582bl_ader
bleaker133510532bleaker
bleater94515302bleater
bleeder10359642bleeder
blender104613842blender
cleaner93712302cleaner
clearer93710822clearer
cleaver124110802cleaver
coleader1139182coleader
deader84220472_deader
gleamer10328512gleamer
gleaner8379772gleaner
header104422542_header
impleader1444112impleader
kneader1275892kneader
lader65633722_l_ader
leaded84221542_leaded
leaden74515222_leaden
leaders83819602_leaders
leadier83212722_leadier
leaker104620072_leaker
leaner64022192_leaner
leaper88118942_leaper
leaser65322672_leaser
leaver94321512_leaver
lender73921272_lender
lewder10479612_lewder
loader74316312_loader
oleander936402oleander
parader103914862parader
placer105117742pl_acer
planer84122652pl_aner
plater84427692pl_ater
player115215212pl_ayer
plead85818462plead__
pleads94613952plead_s
please84315732please_
pleased103712072pleased
pleasers104010292pleasers
pleases94515482pleases
pleated103816632pleated
pleaters103613792pleaters
pleather1356652pleather
pledger11359172pledger
pleiades1145752pleiades
plodder1146002plodder
plunder103810502plunder
preaver121011612preaver
reader73628292_reader
repleader1245392repleader
sledder9399202sledder
slender83413592slender
spreader1137482spreader
treader84113832treader

Search took 4 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 Filter1786911076710.390458182.1
2DLD Change Limit107671612.87637437.8
3Display Results61610.0134692.3
 (SQL Overall)178691613.27954495.6
 
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.