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

161 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
tying9601983(None) 
dying105316031dying
eying96117921eying
hying126514741hying
lying95717451lying
stying105414571stying
thing96622961thing
ting56139891t_ing
toying105017301toying
trying104214071trying
tyin76424001tyin_
tyning105510411tyning
typing124110581typing
tyring104613021tyring
vying125111811vying
abying124410412abying
acing87429152acing
aging77026352aging
ahing98928342ahing
aping87327232aping
awing96827322awing
axing138521372axing
ayin76331742ayin_
ayins85321612ayins
baying125222582baying
being84920502being
boing84725552boing
bring85528502bring
buying124213832buying
cling86424672cling
coying124021482coying
crying123612282crying
cuing85420192cuing
ding66940952_ding
doing74923582doing
drying113411602drying
dyeing11428212dyeing
dyings11478132dyings
dyking15458012dyking
eking106614982eking
exing136016812exing
eyeing10429362eyeing
faying134521072faying
fling97023512fling
flying134612152flying
frying134511402frying
going75218492going
guying11379722guying
gybing13355932gybing
gyring113910362gyring
gyving14415712gyving
haying134420612haying
hyping15408482hyping
icing86017752icing
iring66025422iring
joying173810802joying
keying1438042keying
king95933652_king
laying104525702laying
ling57447962_ling
lyings10488502lyings
lysing104710442lysing
maying124421152maying
ohing96018802ohing
oping86322412oping
owing96222722owing
paying123722162paying
piing85218832piing
ping75943592_ping
pitying132910242pitying
plying124312082plying
prying124114802prying
pyin96823232pyin_
pyins105815862pyins
raying105027192raying
retying113213832retying
ring56541152_ring
ruing67221052ruing
ryking14348102ryking
saying104325542saying
shying134211842shying
sing57544172_sing
skying14399982skying
sling66028802sling
spying123913252spying
staying114017322staying
sting65330242sting
string75327562string
styling112910652styling
suing65026362suing
swing96124842swing
tain45548072tain_
tains54936322tains
taint55542282taint
taking114725952taking
taming94023432taming
tang56138662t_ang
taping94222392taping
taring73932282taring
tawing104521552tawing
taxing143816712taxing
taxying1836182taxying
teeing73916972teeing
teind6213612teind
tewing103914822tewing
thin76732382thin_
thine85026852thine
things104914282things
think125018792think
thins85826322thins
thong95014172thong
tiding83520092tiding
tidying1238512tidying
tieing73518762tieing
tiling73426552tiling
timing93619302timing
tin36362172t_in_
tine45855132t_ine
tinge64626612t_inge
tings65329192t_ings
tining74927542tining
tins45251302t_ins
tint46758862t_int
tiny76134632t_iny
tiring74023092tiring
toeing74418472toeing
toking114420722toking
toling73926122toling
tong56434352t_ong
toning74025792toning
toping94122992toping
toting74123792toting
towing103823192towing
trig55528162tri_g
trine54734602trine
truing73913932truing
tsking114210422tsking
tubing93813092tubing
tung55328162t_ung
tuning74016842tuning
twang94511852twang
twig87615772twi_g
twin76023082twin_
twine85822362twine
twinge104210392twinge
twins85118982twins
twiny116012812twiny
tyiyn11635332tyiyn
tyne76325052ty_ne
tything14316572tything
untying1138942untying
using66317962using
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.1101624463.6
2DLD Change Limit538001611.62333148.5
3Display Results1611610.0334878.8
 (SQL Overall)1786911611.766101184.0
 
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.