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

194 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
elated7472582(None) 
alated75625151alated
belated103520011belated
delated93722871delated
elate55335881elate_
elater64724201elater
elates65032361elates
eluted74915261eluted
gelated93615641gelated
lated65240671_lated
plated95225771plated
related83327571related
slated75028311slated
abated95918452abated
ablated102513442ablated
aerated85322372aerated
alate55340332alate_
alates64833972alates
bated85935532_bated
belaced124112152belaced
belayed133610082belayed
belted94020632bel_ted
berated104422132berated
bladed104717762bladed
blamed116017952blamed
blared95018242blared
blasted104213472blasted
blate75933782blate_
blatted104812712blatted
blawed124713892blawed
blazed184314712blazed
bleated104015972bleated
bloated104513432bloated
boated94221972boated
cerated103922472cerated
chelated142610482chelated
clawed125115072clawed
clayed125013042clayed
cleated103417842cleated
coated94927042coated
crated94827772crated
dated75530992_dated
dealated103213602dealated
debated113916082debated
deflated133412302deflated
delate73827752delate_
delates83526282delates
delayed123310762delayed
deleted93314912deleted
derated93623502derated
dilated93115822dilated
doated84118182doated
eared65139502e_ared
eased65430402e_ased
eaten55323052e_aten
eater54639842e_ater
eaved95924502e_aved
edited83913672edited
eland65820392ela_nd
elapid939542elapid
elapsed1056102elapsed
elatedly1244792elatedly
elaterid948612elaterid
elaters74420192elaters
elected102812612elected
elevated12118292elevated
elided84814672elided
elite56230182elite_
elites66027122elites
eloped95914142eloped
eluate62315432eluate_
eluates72014682eluates
eluded84612772eluded
elute54822572elute_
elutes64020312elutes
emoted94614922emoted
emulated11310792emulated
enacted10310642enacted
enate54428152enate_
enates64026432enates
enlaced102410522enlaced
epilated11310752epilated
equated171910402equated
erased74816752erased
estated83715572estated
evaded1137062evaded
evited104013142evited
exacted1737302exacted
exalted1537392exalted
exapted1736072exapted
exited144712522exited
fated95632132_fated
fellated1239562fellated
felted103714652fel_ted
flaked144715652flaked
flamed124618972flamed
flared105317602flared
flatbed13397982flatbed
flatted114012942flatted
flawed134712722flawed
flayed134414052flayed
flited104616582flited
floated113312702floated
fluted104917162fluted
flyted13378772flyted
gated75329772_gated
gelate73421262gelate_
gelates83219592gelates
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
leaded84221542leaded
leafed105713872leafed
leaked114217702leaked
leaned73422542leaned
leaped94317772leaped
leased74722882leased
leaved105719022leaved
legated92513982legated
letted74118542letted
luted64826142_luted
malted94819862malted
mated85537782_mated
meated94222402meated
melamed1249632melamed
melted94219062mel_ted
moated94819002moated
negated93413232negated
orated74221502orated
pated85237842_pated
pelted94617762pel_ted
placed114318002placed
plaited103713892plaited
planed94420912planed
planted103516122planted
plate74635112plate_
platen84518202platen
plater84427692plater
plates85432242plates
platted103614262platted
played124815032played
pleated103816632pleated
prated94924922prated
rated65441382_rated
rebated103619702rebated
redated93120922redated
reflated123514292reflated
relaced103517212relaced
relate64033632relate_
relater73723142relater
relates73731432relates
relaxed153312532relaxed
relayed113212752relayed
remated103522472remated
replated112817522replated
reslated93517522reslated
salted74121202salted
sated66238532_sated
seated75131062seated
sedated93714352sedated
skated114414882skated
slaked114318272slaked
slanted83514742slanted
slate55438282slate_
slater64429182slater
slates64934062slates
slatey95417062slatey
slatted84015182slatted
slaved104017042slaved
slayed104716222slayed
solated83618022solated
stated75427832stated
teated74924022teated
velate93720142velate_
welted103715822wel_ted

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.346516448.0
2DLD Change Limit825511942.21637252.3
3Display Results1941940.0633079.4
 (SQL Overall)1786911942.62568072.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.