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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

79 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
amyl9551510(None) 
acyl95314291acyl
amyls104512691amyls
aryl75922341aryl
aal39058672a_al
ably99725132ably
aby810238062aby_
abye97921002abye
abys97221882abys
acyls104211522acyls
agly86821802agly
ail37171042a_il
al210674042a__l
alkyl12518042alkyl
all36148232a_ll
ally76935642ally
allyl85310542allyl
am411875562am__
ama510853302am_a
amah98927492amah
amas67746292amas
amble95924642amble
ambo88225142ambo
amen66733152amen
ami56646812am_i
amia66836902amia
amid77036352amid
amie66339852amie
amin66042252amin
amir65129752amir
amis66445322amis
ammo85520132ammo
amok10217402amok
amole75724592amole
amp77541022am_p
ample94720302ample
amply125012912amply
amps86230342amps
ampul91110852ampul
amu58237322am_u
amus65529612amus
amylic13108712amylic
amylum1344692amylum
anal48037522anal
anil46437432anil
any68440492any_
aril45843022aril
army96624182army_
aryls87015812aryls
asyla839332asyla
awl67635302a_wl
awol75620672awol
axal116520492axal
axel115222072axel
axil116424452axil
ay511773892a_y_
aye67151762a_ye
ays67050292a_ys
camel96822802camel
emyd1047072emyd
gamy105427532gamy_
hamal104623112hamal
idyl85912302idyl
mail65543452mail
mall64639372mall
marl66341622marl
maul64830722maul
may88757632may_
maya95824592maya
mayo96524302mayo
mays96940032mays
mel56047482_mel
mil55752112_mil
mol56654592_mol
my78125652_my_
myc106519502_myc
odyl84111462odyl
ramal74622242ramal
tamal73522622tamal

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 Filter178691298720.263679433.5
2DLD Change Limit29872790.92332364.0
3Display Results79790.0136076.9
 (SQL Overall)178691791.199149033.4
 
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.