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

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
dissyllable175316(None) 
dissyllables1862011dissyllables
disyllable1644291di_syllable
dissolvable1753142dissolvable
disyllables1752952di_syllables
decasyllable2061943decasyllable
dissociable1653963dissociable
dissoluble1353173diss_oluble
disyllabic1852603di_syllabic
syllable13177773___syllable
trisyllable1652153trisyllable
assailable1243434_assailable
billable12179504bi___llable
decasyllables2161534decasyllables
dialyzable2542434dialy_zable
disable10516434di_s___able
disavowable2052514disavowable
discardable1753464discardable
discernable1654454discernable
discussable1653554discussable
disenable1249664di_s_enable
dislikable1744324di_slikable
dislikeable1852314dislikeable
dispensable1654984dispensable
displayable1953134displayable
disposable1545864di_sposable
disprovable1953454disprovable
disputable1545054di_sputable
dissemble1445794diss__emble
distillate1146744distilla_te
drillable1245134d__rillable
fillable13179564fi___llable
fissionable1653334fissionable
insolvable1545344_insolvable
isolable1038784_i_s_olable
issuable1046864_iss__uable
killable14168134ki___llable
kissable1436854kiss___able
millable121710134mi___llable
missable12311534miss___able
monosyllable1962564monosyllable
octosyllable1961494octosyllable
polysyllable2261754polysyllable
sellable101711824___sellable
spallable1345834__spallable
spillable1345354__spillable
syllabled15163814___syllabled
syllables14144754___syllables
tillable10159754ti___llable
trisyllables1761304trisyllables
unsellable1247094_unsellable
willable13168684wi___llable

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.1561145455.1
2DLD Change Limit148819528.64017224.4
3Display Results52520.0331575.8
 (SQL Overall)178691528.82920239.1
 
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.