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

105 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
zebroid193647(None) 
ambroid1238882ambroid
ceboid11310652ceb_oid
fibroid1337252fibroid
labroid1038822labroid
negroid9108902negroid
neuroid81110312neuroid
zebraic2044292zebraic
zeroed16409422ze_roed
abroad9310943_abroad
acaroid103512313acaroid
amberoid1346433amberoid
ambroids1346503ambroids
ameboid1277233ameb_oid
android9311513android
aneroid8314013aneroid
aroid65428343__aroid
beblood12106083beblood
becrowd1555183becrowd
bedrid1039943bedr_id
braid85822263__braid
broad84817693__broad
broil74918223__broil
bromid112612893__bromid
brood84620243__brood
cebid104314073ceb__id
ceboids1237653ceb_oids
centroid1159313centroid
cervid1239323ce_rvid
cestoid104011673cestoid
choroid13311803choroid
cuboid1139503cub_oid
debride1138593debr_ide
debris93311493debr_is
deltoid938573deltoid
dendroid1145923dendroid
dentoid9310663dentoid
dermoid1138523dermoid
desmoid1137103desmoid
devoid1189363de_void
droid74218543__droid
embroil1146613embroil
embryoid1644403embryoid
emeroid101511183emeroid
fervid1337513fe_rvid
fibroids1445853fibroids
fibroin1246473fibroin
gabbroid1452763gabbroid
geoid74215763ge__oid
gobioid1146023gobioid
hemoid12313513he_moid
heroic113516923he_roic
heroin94420593he_roin
hybrid15237813hybr_id
hydroid1539713hydroid
jerid132316423je_r_id
jerrid14259143je_rrid
keloid11812623ke_loid
labroids1155843labroids
lemuroid11115173lemuroid
lentoid8310683lentoid
leporid1048153leporid
meloid9616003me_loid
negroids10116333negroids
nereid7312933ne_reid
nevoid1098803ne_void
ochroid1357903ochroid
percoid12312323percoid
period9314983pe_riod
peroxid17310283pe_roxid
rebid85121363reb__id
reboil83814683reb_oil
rebored105015883rebored
rebred95816353rebr_ed
rebreed104611073rebreed
remorid10311863remorid
sparoid102311543sparoid
spiroid10219823spiroid
sporoid102310733sporoid
steroid81314873steroid
tabloid1048263tabloid
tetroxid1646453tetroxid
theroid11313403theroid
thyroid1438253thyroid
toroid7416013_toroid
tuberoid1146013tuberoid
unbraid1037183unbraid
upbraid1244973upbraid
verbid122311313ve_rbid
vibrioid1444413vibrioid
viroid10411523_viroid
zebra1637883zebr__a
zebrano1843853zebrano
zebras1737853zebr_as
zebrass1834113zebrass
zebrawood2451583zebrawood
zebrine1836463zebrine
zero134822473ze_ro__
zeroes154314343ze_roes
zeroing1738343ze_roing
zeros144918113ze_ro_s
zeroth1837963ze_roth
zincoid1946663zincoid
zooid15312103z__ooid
zygoid2045943z_ygoid

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.406440125.6
2DLD Change Limit1340271056.36021073.4
3Display Results1051050.0462282.6
 (SQL Overall)1786911056.81226231.8
 
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.