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

153 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
eking10661499(None) 
deking125614551deking
exing136016811exing
eying96117921eying
king95933671_king
acing87429152acing
aging77026352aging
ahing98928352ahing
akin86328042akin_
aping87327232aping
asking116017232asking
awing96827322awing
axing138521372axing
baking135626622baking
becking164416072becking
being84920502being
biking135018172biking
boing84725552boing
bring85528502bring
caking134624672caking
ceding104014802ceding
cering94522532cering
cling86424672cling
coking134523882coking
cuing85420192cuing
decking153915592decking
dekeing13358352dekeing
dewing114115702dewing
diking124320242diking
ding66940962_ding
doing74923582doing
duking124715132duking
dying105316032dying
dyking15458012dyking
earing75235482earing
easing74926462easing
eating75134402eating
ebbing1137072ebbing
eching126315562eching
edging93510712edging
egging93210982egging
elint55436472elint
ending83220252ending
eng46726782e__ng
eringo739552eringo
erlking1236702erlking
erring73816482erring
evoking1536412evoking
exine125518492exine
eyeing10429362eyeing
faking145520982faking
feeing104416502feeing
feting104417792feting
feuing104412272feuing
fling97023512fling
gecking154111362gecking
geeing84313772geeing
going75218492going
hewing134514242hewing
hexing174210512hexing
hiking143617102hiking
hoking144419512hoking
hying126514742hying
icing86017752icing
inking115119052inking
iring66025422iring
irking114611752irking
jeeing144512142jeeing
jerking19308922jerking
jewing174411422jewing
joking184113022joking
juking183810472juking
kecking134111882kecking
keeking114210892keeking
keying1438042keying
kiang104811362_kiang
kin76353982_kin_
kina85632012_kina
kind96128572_kind
kine85643442_kine
kings105825572_kings
kink76034412_kink
kino86233632_kino
kins85747922_kins
laking115027042laking
leaking123616972leaking
lekking11306502lekking
liking114319582liking
ling57447972_ling
lying95717452lying
making134823852making
meting94320592meting
mewing123914202mewing
miking134218462miking
necking143913892necking
nuking113411252nuking
ohing96018812ohing
oping86322412oping
owing96222722owing
peaking144317692peaking
pecking164017782pecking
peeing94618082peeing
peeking144414952peeking
pekin111514422pekin_
pekins121812232pekins
perking143716462perking
piing85218832piing
piking133719642piking
ping75943602_ping
poking133819302poking
puking133913062puking
raking114728422raking
recking144319922recking
reding83825562reding
reeking123318642reeking
ring56541162_ring
ruing67221052ruing
ryking14348112ryking
seeing74222142seeing
seeking124016062seeking
sering74731812sering
sewing103819622sewing
sexing144313892sexing
sing57544182_sing
skiing113610192skiing
skin85927542skin_
skink85916862skink
skins94723472skins
skint95629232skint
skying14399982skying
sling66028802sling
sting65330242sting
suing65026362suing
swing96124842swing
taking114725952taking
teeing73916972teeing
tewing103914822tewing
thing96622982thing
ting56139922_ting
toking114420722toking
tsking114210422tsking
tying96019842tying
using66317962using
vexing17479172vexing
viking143414612viking
vying125111812vying
waking144821382waking
wing86339232_wing
wring95920712wring
yerking15368812yerking
yeuking15286122yeuking
yoking143912282yoking
zing145728622_zing

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.330541487.9
2DLD Change Limit538001531.70031647.1
3Display Results1531530.0503060.0
 (SQL Overall)1786911532.08085909.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.