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

105 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
dactyls133391(None) 
dactyl1234981dactyl_
dactyli1343601dactyli
dactylus1442471dactylus
acetyls12285352_acetyls
acyls104211522_ac_yls
dactylic1643662dactylic
dactylics1742122dactylics
diacetyls1542252diacetyls
dicotyls1444182dicotyls
octyls11135322_octyls
acetals93411353_acetals
acetyl11396553_acetyl_
actins86321103_actins
actors81016763_actors
acts66929863_act__s
acyl95314293_ac_yl_
adenyls1143923adenyls
alkyls13465723_alkyls
allyls9437273_allyls
amyls104512693_a_myls
artels66216233_artels
aryls87015813_a_ryls
biacetyls1651923biacetyls
butyls1176753_butyls
cacodyls1642713cacodyls
cactus104912233cact_us
cantals93919573cantals
cartels94618123cartels
daces85030683dac__es
dachas124113253dac_has
dacites101114593dacites
dackers143417043dackers
dacoits1079073dacoits
dacrons103211033dacrons
daftly1335443daft_ly
dahls95012283da__hls
daimyos1342813daimyos
dals57145123da___ls
daltons8310403daltons
damsels10126703damsels
darnels83710433darnels
darters84017603darters
dartle73714833dart_le
dartles84014133dartles
darts67635733dart__s
datchas1347423datchas
daters74827373da_ters
dates65639153da_t_es
datos65222783da_t_os
dattos74311903da_ttos
datums936353da_tums
dauties83315763dauties
dauts67822243daut__s
dawties113312703dawties
dawts97216123dawt__s
days87637133da__y_s
decals93717713dec_als
decays124612913decay_s
deckels14367363deckels
decoys123911283decoy_s
dentals83915393dentals
dentils84115583dentils
diacetyl1452913diacetyl_
dicotyl1344403dicotyl_
dictums1235553dictums
dicty115116293dicty__
didactyl1542183didactyl_
distils83015803distils
doctors1039993doctors
dottels8327783dottels
ductal938993ductal_
ductile1048483ductile
ducts85319893duct__s
ductule1065503ductule
ductules1155543ductules
facials123310743facials
factors12912123factors
facts107021893fact__s
fractals1346133fractals
hartals10313023hartals
jacals1539873jac_als
jackals2036893jackals
lactams1136953lactams
lacteals1095663lacteals
maltols939403maltols
mantels94515043mantels
martyrs1234893martyrs
octyl10136063_octyl_
pacts95125803pact__s
pastels95215183pastels
pastils94416173pastils
pentyls1236523pentyls
protyls12298463protyls
ramtils938413ramtils
ratals64219583ra_tals
ratels64518213ra_tels
sacrals93311793sacrals
santols73513323santols
satyrs937963sa_tyrs
syndactyls1951253syndactyls
tactics1149323tactics
tactile9310613tactile
tacts76524123tact__s
trotyls10236033trotyls

Search took 7 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.420425454.8
2DLD Change Limit1340271056.12621878.4
3Display Results1051050.0462282.6
 (SQL Overall)1786911056.59227107.3
 
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.