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

117 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
recycling173490(None) 
bicycling1942882bicycling
cycling1537212__cycling
recalling122211902recalling
recircling1543572recircling
recoaling121312452recoaling
recocking18138372recocking
recoiling121412412recoiling
cyclin1339273__cyclin_
cyclings1635373__cyclings
cyclins1438303__cyclins
cymling1536273__cymling
decocting1538123decocting
decupling1534973decupling
freckling1934703frec_kling
heckling18257163hec_kling
keckling14245523kec_kling
precooling1545963precooling
reaching143317203re_aching
reacting113317893re_acting
rebelling122111163rebelling
rebilling12228833rebilling
reboiling12149823reboiling
recaning111416693rec_aning
recanting122414823recanting
recapping1636453recapping
recasting122414233recasting
receding122713763rec_eding
receiving1538993receiving
recessing12611013recessing
rechecking2244463rechecking
rechewing1836493rechewing
reciting113118073rec_iting
recking144319923re__cking
reckoning1637643reckoning
recline94020493re__cline
reclining121112283reclining
recoating121317463recoating
recoding122213853rec_oding
recoining121313803recoining
recombing1637323recombing
reconciling1645483reconciling
reconning121410793reconning
recooking16148543recooking
recopying1737113recopying
recording131311623recording
recorking16149643recorking
recouping1438363recouping
recoupling1545043recoupling
recrating121318793recrating
recurring1237953recurring
recurving1536773recurving
recusing112512883rec_using
recutting1239483recutting
recycle1445343recycl__e
recycled1634813recycl_ed
recycler1543683recycl_er
recyclers1642973recyclers
recycles1535353recycl_es
redacting13612303redacting
reddling112911813re_ddling
redialing11311843redialing
redocking17126783redocking
reducing12310203reduc_ing
redyeing1336173redy_eing
reedling102414273re_edling
reeling83126863re__eling
refacing142512813refac_ing
refalling132010423refalling
refecting152413353refecting
refeeling13229313refeeling
refelling132211313refelling
refiling123116533re_filing
refilling13299333refilling
refueling13227973refueling
regaling10315363re_galing
reheeling13218263reheeling
rejecting192211153rejecting
relacing112516043relac_ing
relocking16137683relocking
relucting1239773relucting
relying112914613rely__ing
remailing122412473remailing
renailing102813333renailing
reoiling93217213re_oiling
repacking1838283repacking
repealing122513543repealing
repelling122312753repelling
repolling122110203repolling
reracking1639313reracking
rerolling102210373rerolling
resailing103314253resailing
rescaling122212013rescaling
rescuing1139623re_scuing
resealing102115673resealing
resecting122816483resecting
reselling102213833reselling
resiling93520173re_siling
resoling92916303re_soling
restyling1337923restyling
retacking1658973retacking
retackling1744433retackling
retailing103214733retailing
retching143412173re_tching
retelling102112493retelling
retiling93319483re_tiling
retitling1039773retitling
retooling1039093retooling
retying113213833rety__ing
retyping14255613rety_ping
revealing132611883revealing
reveling123117083re_veling
revelling132412553revelling
reviling122917213re_viling
rockling15259383roc_kling
ruckling15258573ruc_kling
unicycling1862843unicycling

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411176.37623312.6
3Display Results1171170.0601950.0
 (SQL Overall)1786911176.85926052.0
 
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.