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

106 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
recycles153535(None) 
recycle1445341recycle_
recycled1634811recycled
recycler1543681recycler
recyclers1642971recyclers
bicycles1743882bicycles
cycles1339302__cycles
recces10614912rec_c_es
recircles1344432recircles
reticles103912482reticles
tricycles1644362tricycles
bicycle1643993bicycle_
bicycled1843133bicycled
bicycler1742693bicycler
bicyclers1842233bicyclers
biocycles1843523biocycles
calycles15295693calycles
cenacles1238023cenacles
cycle1239523__cycle_
cycled1436543__cycled
cycler1335913__cycler
cyclers1435873__cyclers
cyclos1338073__cyclos
debacles1335723debacles
deciles104417723dec_iles
deckles143312803dec_kles
decuples1395283decuples
dicyclies1744033dicyclies
epicycles1843383epicycles
exercycles2461743exercycles
freckles17126383frec_kles
heckles163711383hec_kles
hemicycles2252443hemicycles
icicles1135943_icicles
keckles12318763kec_kles
megacycles2052103megacycles
pedicles1338683pedicles
pericycles1943083pericycles
radicles11249703radicles
reaches123423203re_aches
reales64934123re__ales
recalled11310803recalled
recaller1039323recaller
recallers1137103recallers
recalls92613623rec_alls
recanes93222263rec_anes
recce9514563rec_c_e_
recedes102816063rec_edes
receives1339743receives
recencies13312253recencies
recesses10312323recesses
recipes113314463rec_ipes
recircle1244433recircle_
recircled1443523recircled
recites93524583rec_ites
reckless14257973rec_kless
reclames12310893reclames
reclines103718543reclines
recluses105111733recluses
recoaled113111783recoaled
recoals94214623recoal_s
recocked17248473recocked
recocks154711463recoc_ks
recodes102918633rec_odes
recoiled113613213recoiled
recoiler103210493recoiler
recoilers11318153recoilers
recoils93814873recoil_s
reconciles1447063reconciles
recopies12313733recopies
recouples13116823recouples
recrates102420373recrates
rectoceles1443973rectoceles
recurves1337403recurves
recuses94619463rec_uses
recyclables2051863recyclables
recycling1734903recycling
reddles93315773re_ddles
reduces10513343reduc_es
redyes104214093redy__es
refaces123216743refac_es
refiles104122423re_files
regales83520793re_gales
relaces93420883relac_es
reptiles103913063reptiles
resales74724903re_sales
rescales103414573rescales
rescues9312753re_scues
resiles74026543re_siles
resoles73823653re_soles
restyles1139193restyles
retables101712673retables
retackles1545363retackles
retches123318513re_tches
reticle94112623reticle_
reticules1139013reticules
retiles74426993re_tiles
retitles83612593retitles
retypes12308623rety_pes
reviles104421353re_viles
ruckles133414603ruc_kles
treacles1039703tre_acles
tricycle1543893tricycle_
unicycles16143263unicycles
vehicles16204683vehicles
vesicles13127073vesicles

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621067.59319249.6
3Display Results1061060.0333212.1
 (SQL Overall)1786911068.04622208.7
 
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.