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

49 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
misentry134577(None) 
mesentery1444842mesentery
misandry1443862misandry
misenter10310832misenter
misenters1139532misenters
misery114113542mise__ry
sentry92912052__sentry
absently1345813absently
agentry11165753_agentry
dicentra1145433dicentra
dysentery1643043dysentery
eminently1445303eminently
entry82414263___entry
gentry103410443__gentry
lientery1134883li_entery
lisente71210703lisent_e
masonry1244123mason_ry
mesentera1144653mesentera
millenary1444583millenary
ministry1385793ministry
minty106323903mi__nt_y
miscarry1544473miscarry
miseat82925713miseat__
miseaten10310773miseaten
miseats92815783miseat_s
misenrol1044143misenrol
misentered1345913misentered
misentries1247823misentries
miser75430403mise__r_
miserere1049273miserere
miserly12329823mise_rly
misers85025703mise__rs
misinter1038833misinter
misinters1138183misinters
missent94318713missent__
missilry1344653missilry
misty106120453mis__t_y
momentary1645233momentary
momently1546473momently
musketry1742183musketry
nonentry1146813nonentry
reentry1038033_reentry
senary93716073__senary
silently1147483silently
subentry1344693subentry
vicenary1654973vicenary
wintry12498923wi__ntry
wisent93516343wisent__
wisents10249063wisent_s

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.423422437.4
2DLD Change Limit146162497.18620339.8
3Display Results49490.0163062.5
 (SQL Overall)178691497.62523434.9
 
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.