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 “pygmoid” 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
pygmoid164453(None) 
cymoid1459472cy_moid
pyoid11513762py__oid
sigmoid1146112sigmoid
zygoid2045942zyg_oid
algoid83011473alg_oid
cormoid12310403cormoid
cycloid1539283cycloid
cystoid13309213cystoid
dermoid1138523dermoid
desmoid1137103desmoid
ethmoid1345803ethmoid
geoid74215763__geoid
haemoid1337203haemoid
hemoid12313513_hemoid
hyaloid1439073hyaloid
hydroid1539713hydroid
hyenoid1448613hyenoid
hyoid12612443hy__oid
hypnoid1647883hypnoid
myeloid13108123myeloid
myoid11512993my__oid
myxoid1936883my_xoid
negroid9108893negroid
pagod95013683pag_o_d
pagurid11105443pagurid
percoid12312313percoid
phylloid1746193phylloid
phytoid1678753phytoid
placoid1239773placoid
plasmoid1345583plasmoid
premold1247863premold
prismoid1344983prismoid
promoed12310083promoed
pyemia1337553pyem_ia
pyemic1537893pyem_ic
pygidia1444193pygidia
pygmean1542223pygmean
pygmies15205673pygmies
pygmy16334223pygm__y
pygmyish2241343pygmyish
pygmyism2141813pygmyism
pyralid1347983pyralid
pyramid1547513pyramid
pyranoid1447283pyranoid
pyrenoid1446873pyrenoid
sigmoids1244453sigmoids
typhoid1648133typhoid
xyloid1738193xy_loid

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.1401276364.3
2DLD Change Limit134027496.40620922.1
3Display Results49490.0163062.5
 (SQL Overall)178691496.56227231.2
 
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.