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

95 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
emeroids1114772(None) 
emerods10137651emero_ds
emeroid101511181emeroid_
amberoids1445332amberoids
ambroids1346502ambroids
aneroids9310202aneroids
embroils1245772embroils
embryoids1743392embryoids
emeralds1144592emeralds
emeries91620022emer_ies
emerod9139212emero_d_
energids1045582energids
lemuroids12113682lemuroids
meloids10911452_meloids
steroids9911442steroids
adenoids1056863adenoids
amberoid1346433amberoid_
ambroid1238883ambroid_
ameboid1277233ameboid_
amyloids1446003amyloids
androids1047753androids
aneroid8314003aneroid_
aroids75118223__aroids
asteroids1048743asteroids
ceboids1237653_ceboids
centroids1247043centroids
cheloids1438033cheloids
choroids1438693choroids
clerids1049093cler_ids
demerits11310763demer_its
dermoids1246163_dermoids
droids84712583__droids
embroider1444233embroider
embroiders1543523embroiders
embroil1146613embroi_l
embrowns1544043embrowns
embryoid1644403embryoid_
emends95711433eme__nds
emerald1046923emerald_
emerged11158213emerged_
emerges101310883emer_ges
emerging1237893emerging
emerita938713emer_ita
emeritas1046433emeritas
emeriti949433emer_iti
emeritus1045173emeritus
emersed10138513emersed_
emersion1047733emersion
emersions1147283emersions
emesis84712623eme_si_s
emetics11610723eme_tics
emetins9812653eme_tins
emperies12314563emper_ies
emperors1256123empero_rs
emulsoids1242603emulsoids
energid948303energid_
energies9310783energies
ethmoids1444053ethmoids
euploids1157243euploids
eyefolds1542623eyefolds
eyelids1135943eye_lids
fibroids1445843fibroids
geoids8369843_ge_oids
heroics122912003_heroics
heroins103518013_heroins
hydroids1647763hydroids
jerids142810943_jer_ids
jerrids15277743_jerrids
keloids1288663_keloids
labroids1155843labroids
lemuroid11115173lemuroid_
meloid9616003_meloid_
memoirs1136803_memoirs
mercies113817563_mercies
merits8320873_mer_its
merlins93015813_merlins
mermaids1355753_mermaids
meropias1249963_meropias
meteoroids1353813meteoroids
mucoids1237423_mucoids
murids93212193_mur_ids
negroids10116323negroids
nereids838743_nereids
overbids14248903overbids
percoids1339663_percoids
periods10312243_periods
peroxids1837453_peroxids
sparoids11218713sparoids
spheroids1545543spheroids
steroid81314863steroid_
theroid11313403theroid_
thyroids1546003thyroids
toroids8310643_toroids
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.423422437.4
2DLD Change Limit146162957.39019778.3
3Display Results95950.0303166.7
 (SQL Overall)178691957.84322783.5
 
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.