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

234 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
slated7502831(None) 
alated75625141alated
elated74725821elated
lated65240671_lated
plated95225771plated
salted74121201salted
sated66238531s_ated
seated75131061seated
skated114414881skated
slaked114318271slaked
slanted83514741slanted
slate55438281slate_
slater64429181slater
slates64934061slates
slatey95417061slatey
slatted84015181slatted
slaved104017041slaved
slayed104716221slayed
solated83618021solated
stated75427831stated
abated95918452abated
ablated102513442ablated
alate55340322alate_
alates64833962alates
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
estated83715572estated
fated95632132_fated
flaked144715652flaked
flamed124618972flamed
flared105317602flared
flatbed13397982flatbed
flatted114012942flatted
flawed134712722flawed
flayed134414052flayed
flited104616582flited
floated113312702floated
fluted104917162fluted
flyted13378772flyted
gated75329772_gated
gelated93615632gelated
glared84715192glared
glazed174711772glazed
gloated93511532gloated
grated84523922grated
halted105019602halted
hated95734022_hated
heated104525592heated
isleted837522isleted
isolated9410522isolated
laced87132642_laced
laded74232612_laded
laked105731122_laked
lamed85235292_lamed
lased65132342_lased
lasted74323602_lasted
late47560482_late_
laten54328342_laten
later54843922_later
latex124717112_latex
lathed104718452_lathed
laved95028592_laved
lawed96028322_lawed
layed95127382_layed
lazed154925842_lazed
luted64826142_luted
malted94819862malted
mated85537782_mated
meated94222402meated
moated94819002moated
orated74221502orated
pated85237842_pated
placed114318002placed
plaited103713892plaited
planed94420912planed
planted103516122planted
plate74635112plate_
platen84518202platen
plater84427692plater
plates85432242plates
platted103614262platted
played124815032played
pleated103816632pleated
prated94924922prated
rated65441382_rated
related83327572related
reslated93517522reslated
sabed86526812s_abed
salter64325082salter
saluted84511712saluted
salved103916422salved
saned65636272s_aned
sate45556102s_ate_
satem76021462s_atem
sates54949322s_ates
sauted74119602sauted
saved95127112s_aved
sawed95628402s_awed
sayed96127142s_ayed
scaled94822442scaled
scanted104114392scanted
scaped115519552scaped
scared95227292scared
scarted104816122scarted
scathed134012642scathed
scatted103512772scatted
seabed95017692seabed
sealed74328362sealed
seamed94823882seamed
seared75232842seared
seater64534162seater
sedated93714352sedated
shaded114518872shaded
shafted14288812shafted
shaled105023952shaled
shamed125120212shamed
shaped125020102shaped
shared105829062shared
shaved135118382shaved
shawed134817232shawed
shuted103913172shuted
sifted104313672sifted
silted74020012silted
sited65130742s_ited
skate94721552skate_
skater105015492skater
skates104219402skates
skited114313482skited
slabbed12409502slabbed
slacked143815452slacked
slagged104312772slagged
slake93724052slake_
slaker104219272slaker
slakes104021882slakes
slammed123511102slammed
slanged94112852slanged
slapped123511852slapped
slashed114114852slashed
slat46959022slat__
slatch114510532slatch
slaters73123732slaters
slather103816072slather
slatier74016812slatier
slats55436902slat_s
slaty86523152slat_y
slave84224032slave_
slaver94419612slaver
slaves95023022slaves
slavey124011802slavey
slayer93916332slayer
sleaved113611132sleaved
sled55334372sl__ed
sleeted83113222sleeted
slewed104815522slewed
sliced94416312sliced
slimed94915122slimed
sliped95417062sliped
slitted83513312slitted
sloped94216852sloped
slotted84613882slotted
slowed104617072slowed
slued64220512sl_ued
smarted105012612smarted
snaked115017592snaked
snared74824552snared
snawed104813732snawed
soaked114717592soaked
soaped95817972soaped
soared74324292soared
solaced102911062solaced
solate64526072solate_
solates73523852solates
solvated12237442solvated
sooted73922592sooted
sorted74523712sorted
sotted74121402sotted
spaced114517252spaced
spaded103816752spaded
spaed85522272spa_ed
spared95427492spared
spate74731582spate_
spates85028172spates
spathed134013182spathed
spatted104014142spatted
spayed124213612spayed
spited94820442spited
splatted11356742splatted
splayed13357812splayed
staged84521562staged
staked114621942staked
staled74728102staled
staned74824642staned
stared75429872stared
started84217322started
state56237332state_
stater64427562stater
states64337082states
statued8459892statued
staved103918052staved
stayed104817272stayed
sublated11311502sublated
suited74019422suited
sulcated11310372sulcated
sulfated1238832sulfated
swaged114212252swaged
swathed144611932swathed
swatted114110692swatted
swayed133510262swayed
sweated113411542sweated
teated74924022teated

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.343520965.0
2DLD Change Limit825512342.51632810.4
3Display Results2342340.0802925.0
 (SQL Overall)1786912342.93960799.9
 
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.