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

164 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
lying9571745(None) 
dying105316031dying
eying96117921eying
flying134612151flying
hying126514741hying
laying104525701laying
ling57447961l_ing
lyings10488501lyings
lysing104710441lysing
plying124312081plying
tying96019841tying
vying125111811vying
abying124410412abying
acing87429152acing
aging77026352aging
ahing98928352ahing
allying113011662allying
aping87327232aping
awing96827322awing
axing138521372axing
ayin76331742ayin_
ayins85321612ayins
baying125222582baying
being84920502being
belying133612442belying
bluing94914482bluing
boing84725552boing
bring85528502bring
buying124213832buying
claying133614302claying
cling86424672cling
cloying133511752cloying
cluing93913502cluing
coying124021482coying
crying123612282crying
cuing85420192cuing
ding66940952_ding
doing74923582doing
drying113411602drying
dyeing11428212dyeing
dyings11478132dyings
dyking15458012dyking
eking106614982eking
exing136016812exing
eyeing10429362eyeing
faying134521072faying
flaying143914462flaying
fleying14329872fleying
fling97023512fling
flyings14496062flyings
flyting14378552flyting
frying134511402frying
gleying12318432gleying
gluing83812052gluing
going75218492going
guying11379722guying
gybing13355932gybing
gyring113910362gyring
gyving14415712gyving
haying134420612haying
hyping15408482hyping
icing86017752icing
inlying1168152inlying
iring66025422iring
joying173810802joying
keying1438042keying
king95933662_king
lacing94626232lacing
lading84227122lading
lain46146282lain_
laking115027042laking
laming94528362laming
lang56637382l_ang
lasing74727982lasing
laving104623572laving
lawing104625282lawing
layin84720332layin_
layins93817652layins
lazing164821472lazing
lazying2046672lazying
levying1435872levying
liang64914412liang
liking114319582liking
liming94021242liming
lin37967372l_in_
line46965572l_ine
linga66820822l_inga
lingo66022112l_ingo
lings67135772l_ings
lingy96925142l_ingy
lining74526802lining
link86943442l_ink
linn46034592l_inn
lino46343372l_ino
lins47059052l_ins
lint416266232l_int
liny78141322l_iny
living104318322living
loin46838722loin_
loins56728422loins
long56933342l_ong
looing73621042looing
loping93921412loping
losing74022872losing
loving104416722loving
lowing104623272lowing
loxing143615272loxing
lubing94114042lubing
luging83915292luging
lung55732492l_ung
luring73820752luring
luting75221752luting
lyingly14115262lyingly
lynx1437422ly_nx
lysin84512782lysin_
lysine94210552lysine
lysins94610952lysins
maying124421152maying
ohing96018812ohing
oping86322412oping
owing96222722owing
paying123722162paying
piing85218832piing
ping75943592_ping
playing133816092playing
ploying132811572ploying
prying124114802prying
pyin96823232pyin_
pyins105815862pyins
raying105027192raying
relying112914612relying
ring56541152_ring
ruing67221052ruing
ryking14348112ryking
saying104325542saying
shying134211842shying
sing57544172_sing
skying14399982skying
slaying113316842slaying
sling66028802sling
sluing74315882sluing
spying123913252spying
sting65330242sting
stying105414572stying
suing65026362suing
swing96124842swing
thing96622982thing
ting56139902_ting
toying105017302toying
trying104214072trying
tyin76424002tyin_
tyning105510412tyning
typing124110582typing
tyring104613022tyring
using66317962using
wing86339222_wing
wring95920712wring
wrying13379622wrying
wyling13368552wyling
wyting13277242wyting
yang85626072_yang
yin67648732_yin_
yins75335122_yins
zing145728612_zing

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.310576422.6
2DLD Change Limit538001641.56334421.0
3Display Results1641640.0463565.2
 (SQL Overall)1786911641.91993116.7
 
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.