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 “uranyls” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
uranyls103445(None) 
uranyl936291uranyl_
alanyls1084352alanyls
uracils939372uracils
uranias72113812uranias
uranous7310732uranous
uranylic1343182uranylic
urinals7610252urinals
acyls104211523__acyls
adenyls1143923adenyls
alanyl955483alanyl_
amyls104512693__amyls
anils56326723__anils
aryls87015813__aryls
brails84621293bra_ils
brands95118943bran_ds
branks124817383bran_ks
brans75437433bran__s
brants85723053bran_ts
brasils9410973brasils
brawls115214333bra_wls
brays106723113bra_y_s
brazils1867753brazils
burans85019303buran__s
butanols1044713butanols
canals84421663_canals
craals84113303cra_als
cranes84330753cran_es
crankle133610063crankle
crankles143510153crankles
crankly16358123crankly
cranks125015313cran_ks
crawls114712083cra_wls
crenels93711013crenels
cresyls1234753cresyls
darnels83710433darnels
drails74716953dra_ils
drawls105511393dra_wls
drays95819773dra_y_s
durances1158683durances
frails93716473fra_ils
francs114112193fran_cs
frankly17315633frankly
franks134912733fran_ks
frays116920103fra_y_s
frazils1956123frazils
furanes103214863furan_es
furans94515953furan__s
graals74112913gra_als
grails77518783gra_ils
grandly1238743grandly
grands84218243gran_ds
granges93516523granges
granola837913granola
granolas938053granolas
grans64832543gran__s
grants73722473gran_ts
granule839473granule
granules939933granules
grapnels1134393grapnels
gravels113611143gravels
grayly13287963gra_yly
grays95621333gra_y_s
jurants14379213juran_ts
kraals10378433kra_als
murals84016753mura__ls
nonyls957853_nonyls
orals55826483ora__ls
oranges84215333oranges
orangs74116033oran_gs
ourangs8318503ouran_gs
panels84716523_panels
phenyls1534333phenyls
prances113618773prances
prangs94816233pran_gs
pranks124814723pran_ks
prays105022433pra_y_s
propyls14308193propyls
protyls12298463protyls
puranas9712643puran_as
rails55937403_ra_ils
rances84625443_rances
rands65930453_ran_ds
ranees64623963_ranees
ranges73826923_ranges
ranids75118703_ranids
ranis55235833_ran_is
rankle103414883_rankle
rankles113114543_rankles
rankly133910453_rankly
ranks95225733_ran_ks
rants55935343_ran_ts
ranula6311813_ranula
ranulas7311773_ranulas
ratals64219583_ratals
ratels64518213_ratels
ravels94717073_ravels
rayas85922053_ra_yas
rays77642353_ra_y_s
ruanas6311263ruan_as
runnels7329153runnels
stanols739733stanols
trails64622513tra_ils
tramels93812493tramels
trances93919643trances
tranks104017763tran_ks
tranqs155210313tran_qs
trans54933043tran__s
travels104711293travels
trawls94412393tra_wls
trays85623433tra_y_s
trotyls10236033trotyls
ulans54921303ulan__s
unnails738223unnails
unravels1144633unravels
uracil8311543uracil_
uraeus638793ura_eus
urania62516123uran_ia
uranic82315183uran_ic
uranide82212093uranide
uranides92211283uranides
uranism91112513uranism
uranisms1099973uranisms
uranite72515693uranite
uranites82514643uranites
uranium9610023uranium
uraniums10117163uraniums
urares64519093ura_res
uraris63817273ura_ris
urases63723563ura_ses
urates65027763ura_tes
urbanely1343693urbanely
urials64415193ur_ials
urinal6614123urinal_
urines64724123urin_es
urinous7310083urinous
urns46323893ur_n__s
usances967373usances
vinyls12467003_vinyls
wrangle1137383wrangle
wrangles1237463wrangles
wrangs104611913wran_gs

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271427.07618941.1
3Display Results1421420.0463087.0
 (SQL Overall)1786911427.27824552.2
 
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.