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

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

50 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
recyclables205186(None) 
recyclable1943641recyclable_
nonrecyclables2371423nonrecyclables
recallable1445373recallable_
receivables1852463receivables
recycles1535353recyc___les
unrecyclable2152893unrecyclable_
cyclases1537134__cycla_ses
decasyllables2161534decasyllables
delectables16144334delectables
disyllables1752954disyllables
educables1443474_educ_ables
nonrecyclable2262184nonrecyclable_
peccable1648124pec_c_able_
predicables1843814predic_ables
reachable16129654re_achable_
recappable1843724recappable_
receivable1745514receivable_
receptacles1752384receptacles
reclames12310894re__cla_mes
reclosable1444894reclosable_
reconcilable1853394reconcilable_
recordable1545554recordable_
recoupable1645024recoupable_
recycle1445344recyc___le_
recycled1634814recyc___led
recycler1543684recyc___ler
recyclers1642974recycl__ers
reelable10311594re__elable_
refillable1544074refillable_
regulable1246514re_gulable_
relabels1045344re___labels
reliables1145904re__liables
renewables1543404re_newables
repealable1445984repealable_
resalable1138734re_salable_
rescales103414574re_sc_a_les
rescuable1347584re_scuable_
resealable1246184resealable_
resectable1478124resectable_
respectables1873034respectables
restables111511424re__stables
retables101712674re___tables
returnables1352124returnables
reusables1175224re__usables
revealable1545084revealable_
revocable1647004revoc_able_
semblables1642554se_mblables
syllables14144754__syllables
trisyllables1761304trisyllables

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 Filter1786911488190.1531167915.0
2DLD Change Limit148819508.72017066.4
3Display Results50500.0163125.0
 (SQL Overall)178691508.88920102.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.