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

52 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
ethmoid134580(None) 
ethmoids1444051ethmoids
ethmoidal1552762ethmoidal
isthmoid1463092isthmoid
anthoid11313313anth_oid
athetoid1246743athetoid
cormoid12310403cormoid
ctenoid1078683ctenoid
cymoid1459473_cymoid
dermoid1138523dermoid
desmoid1137103desmoid
echinoid1445993echinoid
echoed125211163ech_oed
echoic1339043ech_oic
emeroid101511183emeroid
ephod1139123eph_o_d
ericoid1049893ericoid
erythroid1654943erythroid
etamin81311853etam_in
etheric12311783etheric
ethic101511223eth__ic
ethion938813ethio_n
ethions1038483ethions
ethnic1148853eth_nic
ethnos947053ethno_s
ethos85514193eth_o_s
ethoxy1933923eth_oxy
ethylic1546323ethylic
etymon1134693etymo_n
etymons1244153etymons
euploid1038963euploid
euthyroid1653683euthyroid
haemoid1337203haemoid
hemoid12313513_hemoid
hyoid12612443__hyoid
lithoid1148773lith_oid
method1239033meth_o_d
ochroid1357903ochroid
petaloid1148753petaloid
pygmoid1644533pygmoid
retinoid947353retinoid
sesamoid1144063sesamoid
sigmoid1146113sigmoid
steroid81314873steroid
styloid1137553styloid
tetanoid947203tetanoid
theroid11313403_theroid
thyroid1438253_thyroid
timid84815733_tim_id
toroid7416013_toroid
toxoid1438153_toxoid
tumid84114023_tum_id

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.390458182.1
2DLD Change Limit134027526.50020619.5
3Display Results52520.0301733.3
 (SQL Overall)178691526.92025822.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.