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

167 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
plied8511859(None) 
flied96519431flied
lied55838091_lied
pied75035361p_ied
piled85232991piled
pled75231431pl_ed
plie65127391plie_
plier75221281plier
plies74526511plies
pried84426861pried
ailed66240282ailed
alien56425582alien
alined75221402alined
aliped95414282aliped
allied74217152allied
applied1247482applied
belied95022162belied
bled75729312bl_ed
bleed85019802bleed
blind86319322blind
blued84520322blued
clued84917682clued
cried84624292cried
died66137852_died
dried75321382dried
elide64922642elide
elided84814672elided
filed95331902filed
fled85429772fl_ed
flier86023402flier
flies85630712flies
flited104616582flited
flued95021252flued
fried95322912fried
gied64631982_gied
gled65631142gl_ed
gleed75320572gleed
glide74521592glide
glided94513902glided
glimed105312282glimed
glued75118362glued
hied85434042_hied
iliad64613462iliad
implied1238622implied
ivied94710522ivied
led46254552_l_ed
lid47453522_li_d
lie38264522_lie_
lief76036992_lief
lien45339802_lien
lier45942462_lier
lies46454192_lies
lieu46534362_lieu
liked104523812_liked
lilied73913212lilied
limed85426802_limed
lined64934642_lined
lived95523722_lived
oiled64429472oiled
paced106931682paced
paged95926782paged
paid75737482pai_d
paiked135113432paiked
pained95622852pained
paired95017522paired
paled85538722paled
palier85023562palier
palled94625162palled
palmed114314642palmed
palped114513642palped
palsied102911302palsied
paned85437182paned
pared86946762pared
pated85237842pated
paved115525262paved
pawed115725612pawed
payed115925932payed
ped66751522p__ed
peed76239182p_eed
peined94918842peined
peised94817682peised
pelted94617762pelted
pie55457402p_ie_
pier66035292p_ier
pies66949602p_ies
piked125623312piked
pile65649692pile_
pilea75123952pilea
pilei74021782pilei
piles74742612piles
pilled94222752pilled
pined85935322pined
piped105123162piped
pitied94017252pitied
placed114318002placed
plaid85118302plaid
plaided11409642plaided
plained103812232plained
plaited103713892plaited
planed94420912planed
plated95225772plated
played124815032played
plea66830602pl_ea
plead85818462plead
pleb86123812pl_eb
pleiad947832pleiad
plew97222812pl_ew
plex137321372pl_ex
plica9613372plica
pliers84715152pliers
plink115219122plink
plinked143910892plinked
plod76723272pl_od
plowed124213202plowed
ployed124310562ployed
plumed114412882plumed
plyer106214332plyer
poind84217912poind
poised94918472poised
poked125425392poked
poled84934842poled
policed123212232policed
polies84034582polies
polled94022002polled
ponied94920702ponied
pooed85226242pooed
pored85234512pored
posed85828412posed
poxed154817862poxed
preed85128122preed
priced115018882priced
pride84724732pride
prided103618032prided
prier75027762prier
pries74339532pries
primed115118912primed
prised94322202prised
prized184415392prized
puked124716222puked
puled84926522puled
pulled94322192pulled
pulped114612532pulped
pulsed94013722pulsed
relied74926232relied
replied103914462replied
riled65833252riled
shied96125492shied
skied104417752skied
sled55334372sl_ed
sliced94416312sliced
slid55828982sli_d
slide64725412slide
slier54827242slier
slimed94915122slimed
sliped95417062sliped
slued64220512slued
spied85427712spied
spiled94621992spiled
spliced124310592spliced
splined105013112splined
stied65723032stied
tied55535212_tied
tiled64832942tiled
tried65026912tried
vied86328632_vied
wiled95231552wiled
wried95518562wried

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 Filter178691538001.546115582.8
2DLD Change Limit538001675.5769648.5
3Display Results1671670.453368.7
 (SQL Overall)1786911677.57523589.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.