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

61 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
zygoma214349(None) 
zygomas2243411zygomas
myoma1239272my_oma
myxoma2043942myxoma
zygoid2045932zygoid
zygomata2342842zygomata
zygose19455552zygose
zygote19325482zygote
aboma91114603_aboma
agama85815573_agama
agma77623263_ag_ma
agora6914333_agora
angioma1045753angioma
angora71111573angora
aroma71220143_aroma
azygos1933323azygo_s
azygous2043113azygous
bygone1256173bygone
caeoma1039033caeoma
chroma132912473chroma
coma87134853__coma
cyma116715843cy__ma
dagoba1074943dagoba
dogma96112463dog_ma
gama77035513__gama
glioma935953glioma
goa47343803__go_a
gyoza1836113gy_oza
lipoma1046753lipoma
magma104513573mag_ma
myeloma1444033myeloma
myomas1338293my_omas
myxomas2153903myxomas
noma67529463__noma
pagoda10487873pagoda
pygmy16334223pyg_my
pyjama20303483pyjama
pyrola1139003pyrola
regma84612333reg_ma
rugola736293rugola
rugosa734563rugosa
sigma84513823sig_ma
soma65635293__soma
stoma75918273_stoma
stroma84313073stroma
yeoman1138823_yeoman
yoga87418053_y_oga
yom88043443_y_om_
zeugma1842713zeugma
zoa128529993z__o_a
zoea137118423z__oea
zona136321963z__ona
zoom156722103z_oom_
zooms164415523z_ooms
zygomatic2644823zygomatic
zygoses20436783zygoses
zygosis20405953zygosis
zygotes20355163zygotes
zygotic2254653zygotic
zyme1819114943zy__me
zymosan2143803zymosan

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 Filter1786911127160.1401276364.3
2DLD Change Limit112716615.32621163.3
3Display Results61610.0163812.5
 (SQL Overall)178691615.48232596.0
 
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.