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

209 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
plated9522577(None) 
alated75625151alated
elated74725821elated
lated65240671_lated
pated85237841p_ated
placed114318001placed
plaited103713891plaited
planed94420911planed
planted103516121planted
plate74635111plate_
platen84518201platen
plater84427691plater
plates85432241plates
platted103614261platted
played124815031played
pleated103816631pleated
prated94924921prated
slated75028311slated
abated95918452abated
ablated102513442ablated
alate55340332alate_
alates64833972alates
bated85935532_bated
belated103520012belated
bladed104717762bladed
blamed116017952blamed
blared95018242blared
blasted104213472blasted
blate75933782blate_
blatted104812712blatted
blawed124713892blawed
blazed184314712blazed
bleated104015972bleated
bloated104513432bloated
boated94221972boated
clawed125115072clawed
clayed125013042clayed
cleated103417842cleated
coated94927042coated
crated94827772crated
dated75530992_dated
delated93722872delated
dilated93115822dilated
doated84118182doated
elate55335882elate_
elater64724202elater
elates65032362elates
eluted74915262eluted
epilated11310752epilated
fated95632132_fated
flaked144715652flaked
flamed124618972flamed
flared105317602flared
flatbed13397982flatbed
flatted114012942flatted
flawed134712722flawed
flayed134414052flayed
flited104616582flited
floated113312702floated
fluted104917162fluted
flyted13378772flyted
gated75329772_gated
gelated93615642gelated
glared84715202glared
glazed174711772glazed
gloated93511532gloated
grated84523922grated
halted105019602halted
hated95734022_hated
heated104525592heated
laced87132642_laced
laded74232612_laded
laked105731122_laked
lamed85235292_lamed
lased65132342_lased
lasted74323602_lasted
late47560482_late_
laten54328342_laten
later54843922_later
latex124717112_latex
lathed104718462_lathed
laved95028592_laved
lawed96028322_lawed
layed95127382_layed
lazed154925842_lazed
luted64826142_luted
malted94819862malted
mated85537782_mated
meated94222402meated
moated94819002moated
opiated1039482opiated
orated74221502orated
paced106931682p_aced
paged95926782p_aged
palaced124110782palaced
palate84226792palate_
palates93624942palates
paled85538722p_aled
palled94625162palled
palmated132511002palmated
palmed114314642palmed
palpated13249762palpated
palped114513642palped
palter84423262palter
paned85437182p_aned
panted95024822panted
pared86946762p_ared
parted94228682parted
pasted94426902pasted
pate65350462p_ate_
paten74827342p_aten
pater74740722p_ater
pates76047892p_ates
patted94724682patted
paved115525262p_aved
pawed115725612p_awed
payed115925932p_ayed
peaced115818912peaced
peaked136117402peaked
pealed95322812pealed
pelted94617762pelted
petted94121522petted
phased124011972phased
pileated112711132pileated
piloted10310322piloted
pirated102515612pirated
pitted94319592pitted
placated1338452placated
place94824612place_
placer105117742placer
places104323702places
placet103923672placet
placid114012542placid
plage84520402plage_
plages94520152plages
plagued11307472plagued
plaid85118302pla_id
plaided11409642plaided
plained103812232plained
plaiter93615392plaiter
plane74929142plane_
planer84122652planer
planes85028082planes
planet84228352planet
planked143512282planked
planned103810152planned
planter94017802planter
plashed133712642plashed
plaster93318692plaster
plastid102112522plastid
plat66048872plat__
platan83913692platan
plateau937402plateau
platens94213982platens
platers93924092platers
platier93716292platier
platies93722542platies
plats75531372plat_s
platter93917412platter
platy105021662plat_y
platys11459852platys
player115215212player
pleaded113511262pleaded
pleased103712072pleased
pleater93916332pleater
pled75231432pl__ed
plicated13310642plicated
plied85118592pl_ied
plotted104612372plotted
plotzed19376222plotzed
plowed124213202plowed
ployed124310562ployed
plumed114412882plumed
plutei8408902plutei
ported94223242ported
posted93722492posted
potted94624012potted
pouted94021392pouted
prate75135982prate_
prater84825352prater
prates84633162prates
prayed124815432prayed
pulsated1136852pulsated
punted94618712punted
pupated12319352pupated
putted94220252putted
rated65441382_rated
related83327572related
replated112817522replated
salted74121202salted
sated66238532_sated
seated75131062seated
skated114414882skated
slaked114318272slaked
slanted83514742slanted
slate55438282slate_
slater64429182slater
slates64934062slates
slatey95417062slatey
slatted84015182slatted
slaved104017042slaved
slayed104716222slayed
solated83618022solated
splatted11356742splatted
splayed13357812splayed
stated75427832stated
teated74924022teated
updated11369422updated
uprated103213322uprated

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 Filter178691825510.326548131.9
2DLD Change Limit825512092.20337472.1
3Display Results2092090.0633317.5
 (SQL Overall)1786912092.59268939.4
 
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.