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

158 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
slaty8652315(None) 
platy105021661platy
salty85524381salty
slanty95114841slanty
slat46959021slat_
slate55438281slate
slatey95417061slatey
slats55436901slats
slay76436381sla_y
alary86123442alary
alate55340322alate
blasty115611052blasty
blat66550952blat_
blate75933782blate
blats75132502blats
clary105719612clary
clay95927412cla_y
elate55335882elate
flaky155715582flaky
flamy135217472flamy
flat77147822flat_
flatly123110212flatly
flats86429742flats
flawy145913382flawy
flaxy189012292flaxy
flay106332802fla_y
floaty124210942floaty
fluty114415642fluty
glady105413942glady
glary96018542glary
glazy187410982glazy
lacy95829632_lacy
lady86527152_lady
laity85318902_laity
laky116725822_laky
lat37593402_lat_
late47560482_late
lath76640382_lath
lathy115215062_lathy
lati46438272_lati
lats45962702_lats
latu47934182_latu
lay68865352_la_y
lazy166423072_lazy
malty106721702malty
meaty107021312meaty
paty95234562_paty
peaty105725692peaty
plat66048872plat_
plate74635112plate
plats75531372plats
platys11459852platys
play95928982pla_y
sagy85327082s_agy
salary9515212salary
sally85129712sally
salt45758522salt_
salts55431882salts
sat36288482s_at_
satay84718462s_atay
sate45556102s_ate
sati45539322s_ati
satyr848482s_atyr
say67264762s_a_y
scaly104718722scaly
scanty114014662scanty
scary105222592scary
scat65848372scat_
scats75930602scats
scatt76030092scatt
scatty115310652scatty
seamy105921272seamy
seat47575562seat_
seats54844342seats
shady125416512shady
shaky154616842shaky
shaly114322862shaly
shanty124715112shanty
shat76456592shat_
shay107133342sha_y
silty84721632silty
sixty154912732sixty
skat87037892skat_
skate94721542skate
skats94621532skats
slab67133762sla_b
slabs75322642slabs
slack115021762slack
slag55934352sla_g
slaggy11438792slaggy
slags66525902slags
slain54923572slain
slake93724052slake
slam67737972sla_m
slams74927902slams
slang66324022slang
slangy105411392slangy
slank95822772slank
slant55238702slant
slantly10399322slantly
slants64819082slants
slap66434042sla_p
slaps76025712slaps
slash84719682slash
slatch114510532slatch
slated75028312slated
slater64429182slater
slates64934062slates
slave84224032slave
slavey124011802slavey
slaw77930712sla_w
slaws85222712slaws
slays85723682slays
sleazy18267392sleazy
sleety94112652sleety
slily85820032slily
slimy105417422slimy
slit46250102slit_
slits56128852slits
slitty9329162slitty
slot46049822slot_
sloth85019442sloth
slots54830522slots
slut45040592slut_
sluts54523982sluts
slutty9248002slutty
sly66228562sl__y
slyly11489532slyly
smarty115013792smarty
snaky125113912snaky
snath86419802snath
soapy106114782soapy
softy115414482softy
solate64526072solate
sooty84924832sooty
spacy125415622spacy
spat66548522spat_
spate74731582spate
spats75031382spats
spay96631662spa_y
splat76129342splat_
splats84817302splats
splay105816042spla_y
stagy96618892stagy
stat47352692stat_
state56237332state
stats55933362stats
stay78333722sta_y
sty66227312s__ty
suety85318492suety
swamy136714402swamy
swarty125812382swarty
swat77244442swat_
swath115920382swath
swats85726862swats
sway107128232swa_y
sweaty123710052sweaty
zloty17399792zloty

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 Filter178691538000.1731032896.0
2DLD Change Limit538001581.92028020.8
3Display Results1581580.0463434.8
 (SQL Overall)1786911582.13983539.5
 
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.