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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
plead8581846(None) 
lead56038851_lead
plea66830601plea_
pleads94613951pleads
pleas75627031pleas
pleat74734471pleat
pled75231431ple_d
pleiad947831pleiad
ahead96817052ahead
bead75937922_bead
bleak115915382bleak
blear75918682blear
bleat75737002bleat
bled75729312ble_d
bleed85019802bleed
blend85317452blend
bread85523112bread
clad76225822cl_ad
clean75420412clean
clear76219052clear
cleat76335062cleat
colead94114642colead
dead65434242_dead
delead84112342delead
dread74419022dread
flea75628492flea_
fleam106017282fleam
fleas86423662fleas
fled85429772fle_d
glad65624012gl_ad
gleam86916732gleam
glean65818202glean
gled65631142gle_d
gleed75320572gleed
head87137172_head
ilea45931462ilea_
ileac75814172ileac
ileal56118082ileal
iliad64613462iliad
implead12315822implead
knead10429662knead
lad48165702_l_ad
lea37660182_lea_
leads66028492_leads
leady95618602_leady
leaf76441032_leaf
leak86233712_leak
leal46043272_leal
lean46345242_lean
leap66032682_leap
lear47045952_lear
leas45954182_leas
led46254552_le_d
lend56233672_lend
leud57223422_leud
lewd85716592_lewd
load56730602_load
mead75531602_mead
olea46532722olea_
oread64619602oread
pad68057322p__ad
paean77222722paean
palea75028662palea_
paleae84820292paleae
paleal84716672paleal
paled85538722pale_d
pea56657242p_ea_
peag75431342p_eag
peak106535202p_eak
peal68648102p_eal
pean66147172p_ean
pear69745232p_ear
peas65755062p_eas
peat65967932p_eat
ped66751522p_e_d
peed76239182p_eed
pend75934532p_end
pied75035362pie_d
pilea75123952pilea_
piled85232992pile_d
plaid85118302plaid
plan65833942pl_an
plat66048872pl_at
play95928982pl_ay
pleach134211242pleach
pleaded113511262pleaded
pleader103511752pleader
please84315732please
pleased103712072pleased
pleated103816632pleated
pleats85218592pleats
pleb86123812ple_b
plebe95014872plebe
plebs95814582plebs
pleiads1045222pleiads
plena75816392plena
pleon74216382pleon
plew97222812ple_w
plews105415352plews
plex137321372ple_x
plexal1536842plexal
plied85118592plied
plod76723272pl_od
poleax1547992poleax
poled84934842pole_d
preed85128122preed
pseud867042pseud
puled84926522pule_d
read55942532_read
replead10399012replead
sled55334372sle_d
spread9312532spread
stead65520272stead
tread64821702tread
ulnad65611452ulnad
unlead73312372unlead
upleap10106842upleap
upload9257782upload

Search took 3 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 Filter178691538000.300595636.7
2DLD Change Limit538001181.75030742.9
3Display Results1181180.0303933.3
 (SQL Overall)1786911182.08085909.1
 
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.