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

80 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
masseuse104425(None) 
masseuses1144791masseuses
danseuse942892danseuse
masses85028712masse_s_
masseur935702masseu_r
masseurs1034922masseurs
missense1037962missense
amassers10337843amassers_
amasses93912853amasse_s_
asperse94210663_asperse
asses55629283_asse_s_
assess65710463_asse_ss
assessed945023_assessed
assesses737383_assesses
assets65617663_assets_
assume897563_ass_ume
assure6610773_ass_ure
basses85428303basse_s_
bassets96414823bassets_
casease939323ca_sease
caseose939163ca_seose
cassene93111543casse_ne
cassenes103611293cassenes
cassette1047813cassette
danseuses1044133danseuses
diseuse83110723_diseuse
disseise939853disseise
gashouse1245693gashouse
gassers84714633gassers_
gasses75724783gasse_s_
hassels104311013hassels_
lasses64827593lasse_s_
madhouse1445503madhouse
malleus92911313malleus_
manses84225513manse_s_
marses84827113marse_s_
masers84623453ma_sers_
mashers124621053mashers_
mashes115030003mashe_s_
maskegs14375413maskegs_
maskers133913843maskers_
masque17249383ma_squ_e
masques18239363masques_
massacre1244743massacre
massage1039893mass_age
massages1159883massages
massas85116463mass_as_
masscult12104723masscult
masse75125293ma_s__se
massed94421323masse__d
massedly1444303massedly
masseter1037063masseter
massiest103314423massiest
massifs1237743massifs_
massive12289773mass_ive
massless10277113massless
masters94628923masters_
messes84924343messe_s_
misease92713043m_isease
missels94614813missels_
missenses1148033missenses
misses85130873misse_s_
missets94516573missets_
missus85312293miss_us_
missuses10309683miss_uses
misuse83213643m_is_use
mossers94116193mossers_
mosses85527683mosse_s_
mussels9419843mussels_
musses84624783musse_s_
passee84522023passe__e
passels93913023passels_
passers94717753passers_
passes86030473passe_s_
passus83610293pass_us_
passuses1036773pass_uses
sasses64124393sasse_s_
tassels74510853tassels_
tasses64826763tasse_s_
tassets75012773tassets_

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.440406115.9
2DLD Change Limit146162807.29620033.2
3Display Results80800.0302666.7
 (SQL Overall)178691807.76623009.4
 
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.