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

60 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
zygomas224341(None) 
zygoma2143491zygoma_
myomas1338292my_omas
myxomas2153902myxomas
zygomata2342842zygomata
zygoses20436782zygoses
zygosis20405952zygosis
zygotes20355162zygotes
abomas101113583_abomas
agamas97413443_agamas
agmas85919873_ag_mas
agoras7613343_agoras
angiomas1145813angiomas
angoras8811363angoras
aromas81018613_aromas
azygos1933323azygo__s
azygoses2163313azygoses
azygous2043113azygo_us
bygones1335913bygones
caeomas1138393caeomas
chromas142512683chromas
comas95833003__comas
cymas126417883cy__mas
dagobas1145143dagobas
dogmas105011243dog_mas
gamas85431353__gamas
gliomas1035333gliomas
goas55239943__go_as
gyozas1933603gy_ozas
lipomas1156443lipomas
magmas115512503mag_mas
myelomas1544323myelomas
myoma1239273my_oma_
myxoma2043943myxoma_
nomas74726413__nomas
pagodas11367553pagodas
pyjamas21263523pyjamas
pyrolas1239863pyrolas
rugolas836373rugolas
rugosas844973rugosas
sigmas94111353sig_mas
somas76030373__somas
stomas84816323_stomas
yeoman1138823_yeoman
yogas96615603_y_ogas
zeugmas1942543zeugmas
zoeas145815613z__oeas
zooms164415523z_oom_s
zygoid2045933zygo_id
zygomatic2644823zygomatic
zygomatics2753083zygomatics
zygose19455553zygo_se
zygote19325483zygo_te
zygotic2254653zygotic
zymase201997483zy__mase
zymes1924712943zy__mes
zymosan2143803zymosan
zymosans2243223zymosans
zymoses21608693zymoses
zymosis21487493zymosis

Search took 10 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.300595636.7
2DLD Change Limit134027608.98314920.1
3Display Results60600.063952.4
 (SQL Overall)178691609.34619119.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.