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

198 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
elate5533588(None) 
alate55340321alate
blate75933781blate
delate73827751delate
elated74725821elated
elater64724201elater
elates65032361elates
elite56230181elite
eluate62315431eluate
elute54822571elute
enate54428141enate
gelate73421251gelate
late47560481_late
plate74635111plate
relate64033631relate
slate55438281slate
velate93720141velate
abate76627842abate
ablate82219212ablate
aerate64830552aerate
agate66525152agate
alae45643752ala_e
alane56135612alane
alated75625142alated
alates64833962alates
ate37059242__ate
bate66552422_bate
belated103520012belated
berate84729022berate
blade85923332blade
blae66134642bla_e
blame95625492blame
blare75826232blare
blase75524232blase
blat66550952blat_
blats75132502blats
blaze165520832blaze
blite76225352blite
cate66254602_cate
cerate84829462cerate
chelate122914892chelate
clade85821012clade
clave105420152clave
crate76537402crate
date56443322_date
dealate83617842dealate
debate94419192debate
deflate113613942deflate
delated93722872delated
delates83526282delates
delete73620702delete
derate74531232derate
dilate73220692dilate
ease45042332e_ase
eat36989052e_at_
eaten55323052e_aten
eater54639842e_ater
eath75735662e_ath
eats47054872e_ats
eave75733582e_ave
ecarte84313502ecarte
eclat7523602eclat_
eclats8313032eclats
elain55324702elain
elan46734242ela_n
eland65820392eland
elans55527752elans
elapse857522elapse
elaters74420192elaters
elative10312452elative
elevate101110372elevate
elide64922642elide
elites66027122elites
elope75219342elope
else45923082el_se
eluates72014682eluates
elude64517622elude
eluted74915262eluted
elutes64020312elutes
emote75421192emote
emulate9314122emulate
enates64026422enates
enlace82213232enlace
epilate9314282epilate
equate152012462equate
erase54925492erase
ergate7315142ergate
estate64719762estate
etape74413702etape
evade938182evade
evite85317682evite
fate75444282_fate
fellate10313432fellate
flake125119972flake
flame105124442flame
flare84823632flare
flat77147822flat_
flats86429742flats
flite85424962flite
flute86823752flute
flyte115713942flyte
folate93320392folate
gate55746572_gate
gelated93615632gelated
gelates83219582gelates
gelati73814532gelati
gelato73812952gelato
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
lease55230262lease
leave84723722leave
legate72917452legate
lite47054542_lite
lute46341012_lute
malate84624552malate
mate65154222_mate
metate82720532metate
negate72915572negate
oblate82214742oblate
oleate6318882oleate
orate55133302orate
ovate84214392ovate
palate84226782palate
pate65350462_pate
pedate93117762pedate
pelage9515362pelage
pelite84323002pelite
peltate92013772peltate
place94824612place
plage84520402plage
plane74929142plane
plat66048872plat_
plated95225772plated
platen84518202platen
plater84427692plater
plates85432242plates
plats75531372plats
platy105021662platy
prate75135982prate
prelate9519692prelate
quate144521412quate
rate45458762_rate
rebate84424112rebate
redate74124682redate
reflate103516262reflate
relace83122152relace
related83327572related
relater73723142relater
relates73731432relates
remate84428682remate
replate93420052replate
reslate73520592reslate
sate45556102_sate
sedate73019802sedate
senate63725142senate
skate94721552skate
slake93724052slake
slat46959022slat_
slated75028312slated
slater64429182slater
slates64934062slates
slatey95417062slatey
slats55436902slats
slaty86523152slaty
slave84224032slave
solate64526072solate
spate74731582spate
state56237332state
tate44748602_tate
telae54323292tela_e
urate55432162urate
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.0762351197.4
2DLD Change Limit538001981.84629144.1
3Display Results1981980.0633142.9
 (SQL Overall)1786911981.98590020.7
 
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.