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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
alphyl148408(None) 
alphyls15113951alphyls
alanyl955482alanyl
alkyl12518042al_kyl
allyl85310542al_lyl
alpha1049652alph_a
alphas1139512alphas
acetyl11396553acetyl
achy126316093a_chy_
acyl95314293a__cyl
adenyl1035023adenyl
alanyls1084353alanyls
alary86123443alary_
alchymy2041843alchymy
alcohol1244373alcohol
aldol61212333al_dol
aleph10311393aleph__
alephs1136533aleph_s
algal66518223al_gal
aliya83713483al_iya
alky115920343al_ky_
alkyd13537093al_kyd
alkyls13465723al_kyls
all36148233al___l
allay85620393allay_
allays94313743allays
alley85721673alley_
alleys95113303alleys
allheal1044553allheal
alloy85519973alloy_
alloys94014563alloys
ally76935643al_ly_
allyls9437273al_lyls
aloha8513623aloh_a
alohas9411703alohas
alp56641133alp___
alpaca1047383alpaca
alphorn1246393alphorn
alpine84417373alpine
alps65529243alp__s
althea938213althea
altho86312603alth_o
aludel747863aludel
alway116113923alway_
always12409133always
amply125012913amply_
ampul91110853amp_ul
amyl95515103a__myl
aphid115515393a_phid
aphis105917133a_phis
aphylly1843353a_phylly
appal95315223a_ppal
appall10379743appall
appeal103911613appeal
appel94615893a_ppel
apply125111393apply_
aptly105111813a_ptly
archil11611573archil
archly1437353archly
aryl75922343a__ryl
ashy107717353a_shy_
asphalt1248083asphalt
asphyxy2541383asphyxy
caliphal1544033caliphal
camphol1645793camphol
ethyl1136513_ethyl
glycyl1542793glycyl
hyphal1736413hyphal
lapel73716683lap_el
lapful1156483lapful
lathy115215063lathy_
methyl1436403methyl
palpal104112053palp_al
phyla13469183__phyla
phyle134111153__phyle
ralph1078743ralph__
ralphed1334363ralphed
ralphs1135373ralph_s
sophy136611763sophy_
sylphy1744153sylphy_
zephyr2342083zephyr

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit112716814.90622975.1
3Display Results81810.0332454.5
 (SQL Overall)178691815.31233639.1
 
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.