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

148 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
skeg9531616(None) 
keg86432531_keg
seg45544881s_eg
skag96321511skag
skee85431471skee
skegs105011231skegs
skep105219351skep
skew116218761skew
akee85936812akee
asked106919312asked
asker96418782asker
askew12529412askew
beg65944132_beg
dreg66821652dreg
eke75630092eke_
eked96718022eked
ekes86726602ekes
esker94412982esker
gleg66219802gleg
kea76540912_kea
kef105639662_kef
kegs95824012_kegs
ken76343982_ken
kep96437202_kep
kex146029582_kex
key105833332_key
leg46446112_leg
maskeg13388692maskeg
meg66040952_meg
muskeg13338182muskeg
neg47237342_neg
oke75839482oke_
okeh114615322okeh
okes84936342okes
peg65843062_peg
reg46146492_reg
sae38365182sae_
sag46163402s_ag
sage55044592sage
sake85244962sake_
saker95132022saker
sakes95540752sakes
sang55441222sang
scag76626892scag
sea36161292s_ea
sec55945322s_ec
see35772262s_ee
seed55549482seed
seek85935482seek
seel45042982seel
seem65438562seem
seen46943122seen
seep66540342seep
seer45547042seer
sees45361052sees
sego56525182s_ego
segs54933882s_egs
sei36048932s_ei
sel38253322s_el
sen36058522s_en
ser36752402s_er
set36681252s_et
sew66247262s_ew
sex107043222s_ex
shag86430562shag
she66837692she_
shea76031572shea
shed86536152shed
shes75734352shes
shew108030762shew
shog86025132shog
siege66718442siege
sike87138782sike_
siker95326032siker
sikes96236082sikes
sing57544172sing
ska76925862sk_a
skags104316072skags
skas85325712skas
skat87037892skat
skean94415622skean
skeed105018982skeed
skeen94817402skeen
skees95023122skees
skeet95429182skeet
skeigh14265902skeigh
skein94814402skein
skell94915832skell
skelm114211282skelm
skelp114211422skelp
skene96118122skene
skeps115614252skeps
skews125413802skews
ski74925682sk_i
skid95720912skid
skied104417752skied
skier95119592skier
skies95026832skies
skiey125012892skiey
skim105322492skim
skin85927522skin
skip105421742skip
skis84825282skis
skit85437522skit
skua86113152skua
sky106420992sk_y
skyed13529922skyed
skyey15537222skyey
slag55934352slag
sled55334372sled
slew76228232slew
slog56728272slog
slug55124642slug
smew95017732smew
smog76317412smog
smug75815262smug
snag55827872snag
sned56026052sned
snog55623632snog
snug55218692snug
soke85436262soke_
sokes95031422sokes
song55133672song
spec85821972spec
sped76031492sped
spew95421872spew
squeg1588032squeg
stag57332002stag
stem610628242stem
step67126292step
stet45947322stet
stew77525462stew
stey76224412stey
sue35651462sue_
sued56537932sued
suer45334032suer
sues46247652sues
suet46754822suet
sung55832172sung
swag87526732swag
swig85818022swig
syke115420562syke_
sykes124816862sykes
teg45741622_teg
tsked105910032tsked
uke75727292uke_
ukes86122812ukes
veg76931062_veg

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 Filter178691298720.1401276364.3
2DLD Change Limit298721481.92315534.1
3Display Results1481480.0761947.4
 (SQL Overall)1786911482.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.