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

57 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
byssuses134227(None) 
byssus1133762byssu__s
missuses10309682missuses
passuses1036772passuses
abysses1234863aby_s_ses
assumes967163_assumes
assures7611403_assures
bascules1236683bascules
basques18248673basqu_es
basses85428303b_as_ses
bassists1037183bassists
bassness1096743bassness
bemuses1139293b_emuses
bespouses1345153bespouses
biasses94911653bias_ses
bisques18236893bisqu_es
blesses93812393bles_ses
blisses94911513blis_ses
blouses94014463b_louses
boluses94113833b_oluses
bonuses94212953b_onuses
bosques18217973bosqu_es
bosses85925403b_os_ses
bossies94116833boss_ies
bossisms1244703bossisms
bouses84931783b__ouses
brasses93818353bras_ses
brisses94314313bris_ses
buses75936013b___uses
busses85023383b_us_ses
bypasses1533833bypasses
byssinoses1551713byssinoses
cassises103811743cassises
censuses10187543censuses
cestuses1038083cestuses
cistuses1038283cistuses
cuscuses1235863cuscuses
cypruses1534313cypruses
discuses113112863discuses
diseuses93112763diseuses
disuses84015413_disuses
eyasses10388023eyas_ses
fissures1136573fissures
issues648803_issu_es
lususes736713_lususes
masseuses1144793masseuses
missises103513693missises
misuses93216023_misuses
oyesses1037333oyes_ses
rhesuses1134893rhesuses
risuses73210923_risuses
souses64229243__souses
susses64221053__susses
tissues737463tissu_es
tussises835433tussises
typhuses1643763typhuses
yesses93615813_yes_ses

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit146162576.98620922.1
3Display Results57570.0134384.6
 (SQL Overall)178691577.43524033.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.