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

81 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
medulla104471(None) 
medullae1143201medullae
medullar1143461medullar
medullas1144511medullas
cedilla1036342cedilla
cedula977642cedu_la
medullary1542242medullary
medusa936292medu_sa
medusal1035182medusal
megilla1036272megilla
mulla74317112m__ulla
ampulla1164303ampulla
bedell93610043bedell_
bedells10379363bedells
bulla74620563__bulla
cedillas1145743cedillas
cedulas1058503cedulas
cella75420313ce__lla
dulia61014983__dulia
dull56430443__dull_
dulls64523743__dulls
dully94921633__dully
fecula113310053fecu_la
fella84918653fe__lla
ferula93011173feru_la
macula103013673macu_la
manilla93012473manilla
maquila1844703maquila
maxilla16248193maxilla
medaka1336343med_aka
medal86221333med_al_
medaled113411613medaled
medalled1246893medalled
medallic1345113medallic
medals94218053med_als
meddle103312763med_dle
meddled123210033meddled
meddler11319953meddler
meddles113213253meddles
medfly1535223med_fly
media84721713med__ia
medial93819863medial_
medially14129323medially
medials103914733medials
medical12312513medical
medina94114093med_ina
medlar93010463med_lar
medley1298343med_ley
medullated1442993medullated
medusae1044763medusae
medusan1044713medusan
medusas1036213medusas
megillah1443233megillah
megillas1145893megillas
mell64935613me__ll_
mells75031333me__lls
mesally12119793mesally
mezuza1643533mezu_za
micella11106823micella
modally1338403modally
modular1087363modular
module93011033modu_le
modules102511003modules
moduli9267963modu_li
modulo9256983modu_lo
modulus10245333modulus
morula8710473moru_la
mull65128803m__ull_
mullah113710733m__ullah
mullas84215933m__ullas
mulls75124153m__ulls
nebula857333nebu_la
peculia1147133peculia
perilla9311233perilla
predella1145393predella
radula749313radu_la
sedilia847243sedilia
sequela1663993sequela
tequila1644583tequila
vedalia1145683vedalia
vexilla1744663vexilla

Search took 7 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 Filter1786911340270.393454684.5
2DLD Change Limit134027816.51620568.9
3Display Results81810.0302700.0
 (SQL Overall)178691816.93925751.7
 
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.