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

269 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
slates6493406(None) 
alates64833961alates
elates65032361elates
plates85432241plates
sates54949321s_ates
skates104219391skates
slakes104021881slakes
slate55438281slate_
slated75028311slated
slater64429181slater
slaters73123721slaters
slatey95417061slatey
slats55436901slat_s
slaves95023021slaves
solates73523851solates
spates85028171spates
states64337081states
abates85825032abates
ablates92416902ablates
agates76121332agates
alate55340322alate_
alated75625142alated
ates45047922__ates
bates75846342_bates
blades95221252blades
blames105121862blames
blares85021632blares
blate75933782blate_
blats75132502blat_s
blazes174817352blazes
blites84721212blites
cates75951872_cates
clades94920462clades
claves115020062claves
crates85736052crates
dates65639152_dates
delates83526282delates
dilates83220652dilates
elate55335882elate_
elated74725822elated
elater64724202elater
elaters74420182elaters
elites66027122elites
eluates72014672eluates
elutes64020312elutes
enates64026422enates
estates74520172estates
fates85139232_fates
flakes134118872flakes
flames114723692flames
flanes94522422flanes
flares94521702flares
flats86429742flat_s
flatus94310782flatus
flaxes165015352flaxes
flites95122442flites
flutes95421782flutes
flytes123911562flytes
folates103218452folates
gates65939502_gates
gelates83219582gelates
glaces94218022glaces
glades84820342glades
glares75518862glares
glazes165315642glazes
glutes74517672glutes
grates75429882grates
hates86742572_hates
isolates8613512isolates
laces76141762_laces
lades65141272_lades
lakes95737652_lakes
lames75445542_lames
lanes54946792_lanes
lares54852632_lares
lases54944762_lases
late47560482_late_
lated65240672_lated
laten54328342_laten
latens64620212_latens
later54843922_later
latest63822702_latest
latex124717112_latex
lathes95127492_lathes
laths86022402_laths
latkes104715872_latkes
lats45962702_lat_s
lattes65324202_lattes
laves86039152_laves
laxes125430092_laxes
lazes145129572_lazes
lutes55836662_lutes
malates93522602malates
mates75251362_mates
nates55238332_nates
oblates91913242oblates
oleates7417832oleates
orates64328612orates
palates93624932palates
pates76047892_pates
places104323702places
plages94520152plages
planes85028082planes
plate74635112plate_
plated95225772plated
platen84518202platen
platens94213982platens
plater84427692plater
platers93924082platers
platies93722542platies
plats75531372plat_s
platys11459852platys
prates84633162prates
rates55352012_rates
relates73731422relates
reslates83619492reslates
sabes76437462s_abes
sades65239892s_ades
safes85226722s_afes
sages65339062s_ages
sakes95540752s_akes
sales56055592s_ales
salted74121202salted
salter64325082salter
salters73622252salters
saltest71916512saltest
salties73725772salties
salts55431882salt_s
salutes73716252salutes
salves94221762salves
sanes55649072s_anes
sate45556102s_ate_
sated66238532s_ated
satem76021452s_atem
satis55633672s_atis
sautes63924912sautes
savates10312952savates
saves85838632s_aves
saxes125229342s_axes
scales84529312scales
scapes105122262scapes
scares85033002scares
scathes124515712scathes
scats75930602scat_s
scatts85914662scatts
scutes85219192scutes
seated75131052seated
seater64534152seater
seaters74028932seaters
seats54844342seat_s
sedates83418032sedates
senates73322582senates
shades105924532shades
shakes135024592shakes
shales94731252shales
shames114726222shames
shapes115124942shapes
shares95236412shares
shaves125224932shaves
shotes95321892shotes
shutes93518212shutes
silages82514442silages
silanes72517162silanes
sites56045432s_ites
sixtes133612402sixtes
skate94721542skate_
skated114414872skated
skater105015482skater
skaters113512942skaters
skats94621532skat_s
skites104418032skites
slabs75322642sla_bs
slacks124416532slacks
slags66525902sla_gs
slake93724052slake_
slaked114318272slaked
slaker104219272slaker
slakers114115752slakers
slams74927902sla_ms
slangs75615342slangs
slanted83514742slanted
slants64819082slants
slaps76025712sla_ps
slashes103619102slashes
slat46959022slat__
slatch114510532slatch
slatches131511522slatches
slather103816062slather
slathers113914772slathers
slatier74016812slatier
slatiest82616262slatiest
slatted84015182slatted
slaty86523152slat_y
slave84224032slave_
slaved104017042slaved
slaver94419612slaver
slavers103716502slavers
slavey124011802slavey
slaveys13415202slaveys
slaws85222712sla_ws
slayed104716222slayed
slayer93916332slayer
slayers104513322slayers
slays85723682sla_ys
sleaves103813202sleaves
sleazes162810332sleazes
sleets64318872sleets
slices84022852slices
slides73922182slides
slimes84722042slimes
slipes84921412slipes
slits56128852slit_s
sloes54728872sl_oes
slopes84820452slopes
sloths94911882sloths
slots54830522slot_s
slues54527172sl_ues
sluts54523982slut_s
slypes114410482slypes
smazes174311662smazes
smites83921922smites
snakes103919602snakes
snares65329032snares
snathes104816492snathes
snaths95112912snaths
soaves94218672soaves
solaces93116132solaces
solate64526072solate_
solated83618022solated
solutes73515262solutes
solvates11249672solvates
spaces104722632spaces
spades94222582spades
spaes76029972spa_es
spales84728102spales
spares84834552spares
spate74731582spate_
spathes125116532spathes
spats75031382spat_s
spites84127332spites
splakes1349672splakes
splats84817302splat_s
stactes91914632stactes
stades74626242stades
stages75629492stages
stakes103927292stakes
stales65538292stales
stanes64933402stanes
stapes85028732stapes
stares66038752stares
stases64225562stases
state56237332state_
stated75427832stated
stater64427552stater
staters73922322staters
stats55933362stat_s
statues74614902statues
status65515212status
staves94525192staves
sublates10315002sublates
suites63727402suites
sulfates11310792sulfates
swages104417072swages
swales93920762swales
swathes134115512swathes
swaths125312642swaths
swats85726862swat_s
tates55444982_tates
urates65027762urates

Search took 4 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.1101624463.6
2DLD Change Limit825512692.86028864.0
3Display Results2692690.0932892.5
 (SQL Overall)1786912693.06358338.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.