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

240 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
plate7463511(None) 
alate55340321alate
blate75933781blate
elate55335881elate
late47560481_late
palate84226781palate
pate65350461p_ate
place94824611place
plage84520401plage
plane74929141plane
plat66048871plat_
plated95225771plated
platen84518201platen
plater84427691plater
plates85432241plates
plats75531371plats
platy105021661platy
prate75135981prate
slate55438281slate
abate76627842abate
ablate82219212ablate
agate66525152agate
alae45643752ala_e
alane56135612alane
alated75625142alated
alates64833962alates
aplite8316392aplite
ate37059242__ate
bate66552422_bate
blade85923332blade
blae66134642bla_e
blame95625492blame
blare75826232blare
blase75524232blase
blat66550952blat_
blats75132502blats
blaze165520832blaze
blite76225352blite
cate66254602_cate
clade85821012clade
clave105420152clave
crate76537402crate
date56443322_date
delate73827752delate
dilate73220692dilate
elated74725822elated
elater64724202elater
elates65032362elates
elite56230182elite
eluate62315432eluate
elute54822572elute
enate54428152enate
epilate9314282epilate
fate75444282_fate
flake125119972flake
flame105124442flame
flare84823632flare
flat77147822flat_
flats86429742flats
flite85424962flite
flute86823752flute
flyte115713942flyte
folate93320392folate
gate55746572_gate
gelate73421252gelate
glace87420152glace
glade75121962glade
glare65222952glare
glaze155418162glaze
glute66020902glute
grate64932882grate
hate78450172_hate
irate55627982irate
lace66848472_lace
lade56345982_lade
lake85741602_lake
lame66849292_lame
lane45153332_lane
lase46148512_lase
lat37593402_lat_
lated65240672_lated
laten54328342_laten
later54843922_later
latex124717112_latex
lath76640382_lath
lathe85626712_lathe
lati46438272_lati
latke94817092_latke
lats45962702_lats
latte55426302_latte
latu47934182_latu
lave75642142_lave
laze136235052_laze
lite47054542_lite
lute46341012_lute
malate84624552malate
mate65154222_mate
oblate82214742oblate
oleate6318882oleate
opiate8513462opiate
orate55133302orate
ovate84214392ovate
pace86345772p_ace
page76036102p_age
palace104516912palace
palates93624932palates
pale66055012p_ale
paleate94120002paleate
palet74650802palet
palmate113215232palmate
palpate113213922palpate
palter84423262palter
pane64950292p_ane
pare66760842p_are
pase65346862p_ase
paste74932952paste
pat58089462p_at_
pated85237842p_ated
paten74827342p_aten
pater74740722p_ater
pates76047892p_ates
path99134912p_ath
pats66460852p_ats
paty95234562p_aty
pave96133892p_ave
peace95026082peace
peage84723572peage
pease75231112pease
peat65967932peat_
peats76140192peats
peaty105725692peaty
pedate93117762pedate
pelage9515362pelage
pelite84323002pelite
peltate92013772peltate
phage115113672phage
phase104617212phase
phat95837862phat_
pileate93815922pileate
pirate82322882pirate
piste75824602piste
placate11312432placate
placed114318002placed
placer105117742placer
places104323702places
placet103923672placet
plack135017842plack
plages94520152plages
plague93610852plague
plaice10311552plaice
plaid85118302plaid
plain74823302plain
plait75631572plait
plaited103713892plaited
plaiter93615392plaiter
plaits83816472plaits
plan65833942pla_n
planate9314572planate
planed94420912planed
planer84122652planer
planes85028082planes
planet84228352planet
plank115221142plank
plans75731272plans
plant75437112plant
planted103516122planted
planter94017802planter
plants84921802plants
plaque17317642plaque
plash104616562plash
plasm94114632plasm
plaster93318692plaster
platan83913692platan
platane93112302platane
plateau937402plateau
platens94213982platens
platers93924092platers
platier93716292platier
platies93722542platies
platted103614262platted
platter93917412platter
platys11459852platys
play95928982pla_y
playa105812942playa
played124815032played
player115215212player
plays106320772plays
plaza164311062plaza
please84315732please
pleat74734472pleat_
pleated103816632pleated
pleater93916332pleater
pleats85218592pleats
plebe95014872plebe
plicate11314512plicate
plie65127392pl_ie
plot66141232plot_
plots75025672plots
plotz164617002plotz
plumate1149802plumate
plume94819462plume
plutei8408902plutei
polite83625072polite
prase76128752prase
prat65952042prat_
prated94924922prated
prater84825352prater
prates84633162prates
prats76333392prats
prelate9519692prelate
prolate9419792prolate
pulsate9510232pulsate
pupate104213122pupate
quate144521412quate
rate45458762_rate
relate64033632relate
replate93420052replate
sate45556102_sate
skate94721552skate
slake93724052slake
slat46959022slat_
slated75028312slated
slater64429182slater
slates64934062slates
slatey95417062slatey
slats55436902slats
slaty86523152slaty
slave84224032slave
solate64526072solate
spate74731582spate
splake1259782splake
splat76129342splat_
splats84817302splats
state56237332state
tate44748602_tate
update93810292update
uprate83916542uprate
urate55432162urate
velate93720142velate
zlote143912942zlote

Search took 2 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.296603685.8
2DLD Change Limit538002401.56334421.0
3Display Results2402400.0763157.9
 (SQL Overall)1786912401.93592346.8
 
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.