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 “anthoid” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

119 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
anthoid1131331(None) 
acanthoid1553932acanthoid
android9311512android
aneroid8314002aneroid
antacid10311222antacid
antherid12611092antherid
anthodia1247802anthodia
aunthood1254722aunthood
lithoid1148772lithoid
acaroid103512313acaroid
actinoid1148013actinoid
adenoid959253adenoid
agatoid948623agatoid
ahold94714253a__hold
algoid83011473a_lgoid
altho86312603altho__
althorn1047763althorn
ambroid1238883ambroid
ameboid1277233ameboid
amyloid1348543amyloid
ancho104515303ancho__
anchor113911973ancho_r
anchored1438593anchored
anchors123912953anchors
anchos114214893ancho_s
anchovy1843953anchovy
anconoid1146463anconoid
androids1047753androids
anechoic1545373anechoic
aneroids9310203aneroids
anethol1045383anetho_l
anethole1146253anethole
anethols1145843anethols
annelid838733annelid
antacids1148333antacids
antechoir1453403antechoir
anted66328243ant__ed
anteed75616113ant_eed
antefix1745053antefix
anthelia1149113anthelia
anthelix1845923anthelix
anthem113410343anth_em
anthemed1446953anthemed
anthemia1349193anthemia
anthemic15410323anthemic
anthems12309423anthems
anther93715063anth_er
antherids1368723antherids
anthers103715203anthers
anthesis11312503anthesis
anthill1048203anthill
anthodium1545043anthodium
anthozoic2344523anthozoic
anthrax1757153anthrax
anthropic1648423anthropic
anthropoid1656463anthropoid
anti45536363ant__i_
antiair7310313antiair
antic75728863ant__ic
anticold1147473anticold
antired82316193antired
antis55033313ant__is
antiskid1346673antiskid
antlion7310293antlion
anyhow1544103anyho_w
aphid115515393a_ph_id
aroid65428343a__roid
asteroid9511193asteroid
athetoid1246743a_thetoid
athodyd1542693a_thodyd
aunthoods1344333aunthoods
autacoid1146253autacoid
author939763autho_r
authored1238263authored
authors10311853authors
autocoid1147643autocoid
autoed7712823aut_oed
avoid95516683a__void
cactoid12311033cact_oid
cancroid1346523cancroid
canthi11310973canth_i_
centroid1159313centroid
conchoid1688043conchoid
dentoid9310663dent_oid
entoil6912493ent_oil
ethmoid1345803_ethmoid
factoid1338693fact_oid
fantod102010033fant_o_d
ganoid8314443gan__oid
handhold1645633handhold
introit7414533introit
isthmoid1463093isthmoid
lanthorn1147193lanthorn
lentoid8310683lent_oid
lithoed1137833lithoed
manatoid1148823manatoid
manhood1338993man_hood
mantid93820383mant__id
mastoid10711233mast_oid
mattoid1079283mattoid
method1239023metho_d
mythoi14417133mythoi_
naevoid1194593naevoid
nevoid1098793_nevoid
ornithoid1352973ornithoid
osteoid848193osteoid
sainthood1343903sainthood
typhoid1648133typhoid
unhood1039233un_hood
unshod1067603unsho_d
untold7149683unt_old
untrod769853untro_d
xanthein1845013xanthein
xanthic1945863xanth_ic
xanthin1747043xanth_in
xanthoma2043973xanthoma
xanthone1847113xanthone
xanthous1846643xanthous
xiphoid2045923xiphoid

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.393454684.5
2DLD Change Limit1340271195.81023068.3
3Display Results1191190.0333606.1
 (SQL Overall)1786911196.23628654.7
 
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.