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 “eying” 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
eying9611792(None) 
dying105316031dying
eking106614981eking
exing136016811exing
eyeing10429361eyeing
hying126514741hying
keying1438041keying
lying95717451lying
tying96019841tying
vying125111811vying
abying124410412abying
acing87429152acing
aging77026352aging
ahing98928352ahing
aping87327232aping
awing96827322awing
axing138521372axing
ayin76331742ayin_
ayins85321612ayins
baying125222582baying
being84920502being
belying133612442belying
boing84725552boing
bring85528502bring
buying124213832buying
ceding104014802ceding
cering94522532cering
cling86424672cling
coying124021482coying
crying123612282crying
cuing85420192cuing
defying15328822defying
deking125614552deking
denying123711292denying
dewing114115702dewing
ding66940952_ding
doing74923582doing
drying113411602drying
dyeing11428212dyeing
dyings11478132dyings
dyking15458012dyking
earing75235482earing
easing74926462easing
eating75134402eating
ebbing1137072ebbing
eching126315562eching
eddying1335292eddying
edging93510712edging
egging93210982egging
elint55436472elint
ending83220252ending
eng46726782e__ng
envying1435712envying
eringo739552eringo
erring73816482erring
espying1336192espying
exine125518492exine
eyen76223662eyen_
eyne76322462ey_ne
faying134521072faying
feeing104416502feeing
feting104417792feting
feuing104412272feuing
fleying14329872fleying
fling97023512fling
flying134612152flying
frying134511402frying
geeing84313762geeing
gleying12318432gleying
going75218492going
greying124110892greying
guying11379722guying
gybing13355932gybing
gyring113910362gyring
gyving14415712gyving
haying134420612haying
hewing134514242hewing
hexing174210512hexing
hyping15408482hyping
icing86017752icing
iring66025422iring
jeeing144512142jeeing
jewing174411422jewing
joying173810802joying
king95933652_king
laying104525702laying
levying1435872levying
ling57447962_ling
lyings10488502lyings
lysing104710442lysing
maying124421152maying
meting94320592meting
mewing123914202mewing
obeying1336542obeying
ohing96018812ohing
oping86322412oping
owing96222722owing
paying123722162paying
peeing94618082peeing
piing85218832piing
ping75943592_ping
plying124312082plying
preying133114552preying
prying124114802prying
pyin96823232pyin_
pyins105815862pyins
raying105027192raying
reding83825562reding
relying112914612relying
retying113213832retying
ring56541152_ring
ruing67221052ruing
ryking14348112ryking
saying104325542saying
seeing74222142seeing
sering74731812sering
sewing103819622sewing
sexing144313892sexing
shying134211842shying
sing57544172_sing
skying14399982skying
sling66028802sling
spying123913252spying
sting65330242sting
stying105414572stying
suing65026362suing
swing96124842swing
teeing73916972teeing
tewing103914822tewing
thing96622982thing
ting56139902_ting
toying105017302toying
trying104214072trying
tyin76424002tyin_
tyning105510412tyning
typing124110582typing
tyring104613022tyring
using66317962using
vexing17479172vexing
wing86339222_wing
wring95920712wring
wrying13379622wrying
wyling13368552wyling
wyting13277242wyting
yang85626062_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.0931921408.6
2DLD Change Limit538001481.42037887.3
3Display Results1481480.0502960.0
 (SQL Overall)1786911481.563114325.7
 
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.