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

56 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
disyllables175295(None) 
dissyllables1862021dissyllables
disyllable1644291disyllable_
dissyllable1753162dissyllable_
syllables14144752__syllables
trisyllables1761302trisyllables
decasyllables2161533decasyllables
disables11410903dis___ables
disenables1346233dis_enables
disposables1653633disposables
disyllabic1852603disyllab_ic
syllable13177773__syllable_
syllabled15163813__syllabled
trisyllable1652153trisyllable_
billable12179504bi__llable_
decasyllable2061944decasyllable_
desirables1344214des_irables
diallages1145464di_alla_ges
dialyzable2542434dialyzable_
disable10516434dis___able_
disabled1248714dis___abled
disabler1147914dis___abler
disablers1255804dis___ablers
disenable1249674dis_enable_
disenabled1444914dis_enabled
dislikable1744324dislikable_
displaces1448594dis_pla_ces
displayable1953134displayable_
displeases1345684displea_ses
disposable1545874disposable_
disputable1545064disputable_
dissembles1545084dis_sembles
dissoluble1353174dissoluble_
dissolvable1753144dissolvable_
distillates1246154distilla_tes
disulfates14145364disulfa_tes
drillable1245134d_rillable_
fillable13179574fi__llable_
isolable1038794_is_olable_
killable14168134ki__llable_
millable121710134mi__llable_
miserables1445614mis_erables
mislabels13114314mis__labels
monosyllables2061924monosyllables
octosyllables2071164octosyllables
polysyllables2371434polysyllables
recyclables2051864recyclables
sellable101711824__sellable_
syllabics1643644__syllabics
syllabizes2443834__syllabizes
syllabubs1652114__syllabubs
syllabus1343814__syllab_us
syllabuses1552574__syllabuses
tillable10159754ti__llable_
unsellable1247094unsellable_
willable13168684wi__llable_

Search took 10 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.453394461.4
2DLD Change Limit148819568.67317158.9
3Display Results56560.0301866.7
 (SQL Overall)178691569.15619516.3
 
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.