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

111 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
aneroids931020(None) 
androids1047751androids
aneroid8314001aneroid_
adenoids1056862adenoids
amberoids1445332amberoids
ambroids1346502ambroids
android9311512android_
anergias947172anergias
anergies9310452anergies
aroids75118222a__roids
asteroids1048742asteroids
cancroids1444532cancroids
emeroids11147722emeroids
energids1045582energids
negroids10116322_negroids
nereids838742_nereids
steroids9911442steroids
acarids105312243acar_ids
acaroid103512313acaroid_
acerolas1048053acerolas
acerous9513333acero_us
adenoid959253adenoid_
aeries64737783a_er_ies
aerobes9311493a_erobes
aerobics1246833a_erobics
amberoid1346433amberoid_
ambroid1238883ambroid_
ameboid1277233ameboid_
amyloids1446003amyloids
anaerobes1144993anaerobes
andros7313303andro__s
anemias92512143ane_mias
anemones10249473anemones
anemoses10159433anemoses
anemosis10148073anemosis
anergia847363anergi_a
anergic1048113anergi_c
aneuploids1362403aneuploids
aneurins849073aneurins
annelids946233annelids
anserous8410543ansero_us
antacids1148333antacids
anterooms11119603anterooms
antherids1368723anther_ids
anthoid11313313anthoid_
anurias7312253anur_ias
anurous7311553anuro_us
aperies9423203aper_ies
aroid65428343a__roid_
asteroid9511193asteroid_
avoids104410203a__voids
bacteroids1545203bacteroids
cancroid1346523cancroid_
catenoids1246433catenoids
ceboids1237653_ceboids
centroids1247043centroids
chancroids1873223chancroids
cheloids1438033cheloids
choroids1438693choroids
clerids1049093cler_ids
dermoids1246163_dermoids
droids84712583__droids
emerods10137653emero_ds
emeroid101511183emeroid_
energid948303energid_
energies9310783energies
fibroids1445843fibroids
ganoids939333gan__oids
geoids8369843_ge_oids
heroics122912003_heroics
heroins103518013_heroins
hydroids1647763hydroids
inertias8410383inertias
inroads837043in_roads
introits859713introits
jerids142810943_jer_ids
jerrids15277743_jerrids
keloids1288663_keloids
labroids1155843labroids
lacertids1244153lacertids
lentoids947443lentoids
meloids10911453_meloids
naevoid1194593naevoid_
negroid9108893_negroid_
nerds65719253_ner__ds
nereid7312923_nereid_
nereides938503_nereides
nereis6315343_nerei_s
nerolis71012773_nerolis
nerols6914883_nero_ls
neuroid81110303_neuroid_
nevoid1098793_nevoid_
onerous7312973onero_us
overbids14248903overbids
panbroils1343223panbroils
percoids1339663_percoids
periods10312243_periods
peroxids1837453_peroxids
planetoids1344093planetoids
sangfroids1551673sangfroids
sparoids11218713sparoids
spheroids1545543spheroids
steroid81314863steroid_
synergids1443013synergids
theroid11313403theroid_
thyroids1546003thyroids
toroids8310643_toroids
unbraids1144963unbraids
underbids13137243underbids
verbids13259203_verbids
viroids1137923_viroids

Search took 8 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621116.76621602.4
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.21824756.3
 
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.