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 “myomata” 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
myomata144592(None) 
myxomata2243381myxomata
magmata1237462magmata
myelomata1653342myelomata
myoma1239272myom__a
myomas1338302myoma_s
somata8312382_somata
stomata938532stomata
zygomata2342842zygomata
abomasa11114613abomasa
automata1047963automata
bemata10411693_bemata
bromate11313553bromate
celomata1296633celomata
comate104124843_comate
commata1338483commata
cymatia1446443cy_matia
dogmata1145143dogmata
edemata1046003edemata
empyemata1851773empyemata
enemata948013enemata
fermata12278143fermata
gliomata1143543gliomata
gummata1244613gummata
lemmata1144673lemmata
lipomata1244563lipomata
mammate104411273mammate
mammati10398373mammati
miasmata1244503miasmata
mismate111415353mismate
moat66352033m_o_at_
moats75827643m_o_ats
momenta11299853m_omenta
momma85111053m_om_ma
mycetomata1952053mycetomata
myomatous1643793myomatous
myopathy2143113myopathy
myopia13318443myo_pia
myosote1245853myosote
myxoma2043943myxom__a
myxomas2153913myxoma_s
omasa749483__omasa
regmata1036193regmata
sonata6313223_sonata
stomatal1045833stomatal
stomate9313123stomate
stromata1047593stromata
tomato8313453_tomato
trymata1244223trymata

Search took 6 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.406440125.6
2DLD Change Limit134027495.48624430.7
3Display Results49490.0163062.5
 (SQL Overall)178691495.90830245.6
 
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.