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

52 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
tricycles164436(None) 
tricycle1543891tricycle_
bicycles1743882_bicycles
epicycles1843382epicycles
pericycles1943082pericycles
recycles1535352_recycles
trickles143013762tric_kles
tricyclic1553152tricyclic
tricyclics1652362tricyclics
unicycles16143262unicycles
bicycle1643993_bicycle_
bicycled1843133_bicycled
bicycler1742693_bicycler
bicyclers1842233_bicyclers
biocycles1843523biocycles
brickles162810283bric_kles
bricoles122610303bric_oles
cycles1339303___cycles
dicyclies1744033_dicyclies
epicycle1743393epicycle_
hemicycles2252443hemicycles
icicles1135943__icicles
pericycle1843113pericycle_
prickles162511093pric_kles
recycle1445343_recycle_
recycled1634813_recycled
recycler1543683_recycler
recyclers1642973_recyclers
strickles1567813stric_kles
tickles133416853t_ic_kles
trachles13311753trac_hles
treacles1039703tr_eacles
triangles1035743triangles
triazoles1844393triazoles
tricepses1354643tricepses
trices84826333tri__c_es
trichites1448883trichites
trichomes16107553trichomes
trichoses14107963trichoses
trickle133613443tric_kle_
trickled152610433tric_kled
tricornes1146233tricornes
trifles103814823tri__fles
trindles93211683tri_ndles
triples94616873tri__ples
trisceles1145293trisceles
triskeles1344273triskeles
triticales1246263triticales
truckles14319383truc_kles
unicycle15153183unicycle_
unicycled17143503unicycled
utricles1037223utri__cles

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.420425454.8
2DLD Change Limit148641526.15624145.7
3Display Results52520.0301733.3
 (SQL Overall)178691526.60627049.8
 
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.