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

110 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
negroid910889(None) 
negroids10116321negroids
neuroid81110301neuroid
aneroid8314002ane_roid
negroni846832negroni
negronis947262negronis
nereid7312922ne_reid
nevoid1098792ne_void
zebroid1936462zebroid
acaroid103512313acaroid
algoid83011473alg_oid
ambroid1238883ambroid
android9311513android
aneroids9310203ane_roids
aroid65428343__aroid
becrowd1555173becrowd
bedrid1039943bedr_id
begrim11118333begr_im
begroan1036103begroan
ceboid11310653ce_boid
centroid1159313centroid
cervid1239323ce_rvid
cestoid104011673cestoid
choroid13311803choroid
degreed10258883degreed
deltoid938573deltoid
dendroid1145923dendroid
dentoid9310663dentoid
dermoid1138523dermoid
desmoid1137103desmoid
devoid1189363de_void
droid74218543__droid
emeroid101511183emeroid
energid948303energid
engrail846263engrail
engrain838353engrain
engross837123engross
fervid1337513fe_rvid
fibroid1337243fibroid
geoid74215763__geoid
grid65829613__gr_id
groin65521083__groin
hemoid12313513he_moid
heroic113516923he_roic
heroin94420593he_roin
hydroid1539713hydroid
jerid132316423je_r_id
jerrid14259143je_rrid
keloid11812623ke_loid
labroid1038823labroid
legroom1076093legroom
lemuroid11115173lemuroid
lentoid8310683lentoid
leporid1048153leporid
ligroin848043ligroin
megrim1178043megr_im
meloid9616003me_loid
naevoid1194593naevoid
neared75119803near_ed
nearside944913nearside
necrose939723necrose
necrosed1137213necrosed
necrosis1048883necrosis
necrotic12310043necrotic
negated93413233negated
negrophil1554953negrophil
nerd56624943ne_r__d
nereids838743ne_reids
nereis6315343ne_reis
nerol51017813ne_ro_l
neroli61111153ne_roli
nerolis71012773ne_rolis
nerols6914883ne_rols
nerved104111683ne_rved
neuroma946523neuroma
neuron6310373neuro_n
neurone739433neurone
neuronic1049013neuronic
neurons7410443neurons
neurosis848843neurosis
neurotic1039693neurotic
nigrosin945233nigrosin
nimrod934873nimro_d
nitrid72812233nitr_id
ochroid1357903ochroid
percoid12312313percoid
period9314983pe_riod
peroxid17310263pe_roxid
pygmoid1644533pygmoid
regrind938983regrind
regroom1077293regroom
reground1045073reground
regroup1095173regroup
regrow10309883regro_w
regrown11237363regrown
regrows11269153regrows
remorid10311863remorid
sigmoid1146113sigmoid
sparoid102311543sparoid
spiroid10219823spiroid
sporoid102310733sporoid
steroid81314863steroid
tetroxid1646443tetroxid
theroid11313403theroid
thyroid1438253thyroid
toroid7416013_toroid
verbid122311313ve_rbid
viroid10411523_viroid
zeroed16409413ze_roed
zygoid2045943zyg_oid

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271107.46617951.6
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.66823303.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.