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

166 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
skate9472155(None) 
sate45556101s_ate
skat87037901skat_
skated114414881skated
skater105015491skater
skates104219401skates
skats94621541skats
skite95120051skite
slate55438281slate
spate74731581spate
state56237331state
abate76627842abate
agate66525152agate
alate55340322alate
ate37059242__ate
bate66552422_bate
blate75933782blate
cate66254602_cate
crate76537402crate
date56443322_date
elate55335882elate
enate54428142enate
estate64719762estate
fate75444282_fate
gate55746572_gate
grate64932882grate
hate78450172_hate
ikat87626642ikat_
ikats95311152ikats
irate55627982irate
kae76744542_ka_e
kale86533752_kale
kame105728232_kame
kane85133972_kane
kat77468292_kat_
kata85626022_kata
kats85944332_kats
kite85338232_kite
kyte117017762_kyte
late47560482_late
mate65154222_mate
orate55133302orate
ovate84214392ovate
pate65350462_pate
plate74635112plate
prate75135982prate
quate144521412quate
rate45458762_rate
sabe66140572s_abe
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sale44959702s_ale
same65245642s_ame
sane45954342s_ane
sat36288482s_at_
sated66238532s_ated
satem76021462s_atem
sates54949322s_ates
sati45539332s_ati
saute55028082saute
savate9313782savate
save75741362s_ave
scale74629142scale
scape96921842scape
scare75334462scare
scat65848372scat_
scathe114414992scathe
scats75930602scats
scatt76030092scatt
scute75520942scute
seat47575562seat_
seated75131052seated
seater64534152seater
seats54844342seats
sedate73019802sedate
senate63725142senate
sente56432872sente
setae56026222setae
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shat76456602shat_
shave114425892shave
shote85526102shote
shute84520352shute
site47052412s_ite
sixte126216582sixte
ska76925862ska__
skag96321512ska_g
skags104316072skags
skald104210172skald
skank84415582skank
skas85325712ska_s
skaters113512962skaters
skatol1035722skatol
skatole1135692skatole
skeane104611372skeane
skee85431472sk_ee
skeet95429182skeet
skene96118122skene
skit85437532skit_
skited114313482skited
skites104418042skites
skits94721862skits
skive124614112skive
slake93724052slake
slat46959022slat_
slated75028312slated
slater64429182slater
slates64934062slates
slatey95417062slatey
slats55436902slats
slaty86523152slaty
slave84224032slave
smaze165012932smaze
smite75224872smite
smote75820282smote
snake94821112snake
snare54429982snare
snath86419802snath
snathe94415112snathe
soave84219052soave
solate64526072solate
space95325672space
spade84423322spade
spae65034322spa_e
spake114322742spake
spale74929212spale
spare75135562spare
spat66548522spat_
spates85028172spates
spathe115115692spathe
spats75031382spats
spite75430662spite
stacte82113912stacte
stade64825302stade
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
stare54440262stare
stat47352692stat_
stated75427832stated
stater64427562stater
states64337082states
stats55933362stats
statue66015322statue
stave85324992stave
suave83519872suave
suite54829562suite
swage94919562swage
swale85221592swale
sware85828212sware
swat77244442swat_
swath115920382swath
swathe125514112swathe
swats85726862swats
tate44748602_tate
ukase9428492ukase
urate55432162urate

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.0961861364.6
2DLD Change Limit538001661.51335558.5
3Display Results1661660.0503320.0
 (SQL Overall)1786911661.659107710.1
 
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.