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

155 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
lentoid831068(None) 
dentoid9310661dentoid
lentoids947441lentoids
centroid1159312centroid
cestoid104011672cestoid
deltoid938572deltoid
entoil6912492_entoil
glenoid937802glen_oid
lentic83515742lent_ic
lentil64315392lent_il
lento57223392lento__
lentos65317402lento_s
adenoid959253aden_oid
agatoid948623agatoid
allantoid1094863allantoid
aneroid8314013aneroid
anthoid11313313_anthoid
benthic1437473benthic
bento75922953bento__
bentos86218313bento_s
bentwood1444453bentwood
benzoic2045033benzoic
benzoin1846263benzoin
bestrid1039973bestrid
blennioid1281663blennioid
cactoid12311033cactoid
ceboid11310653ce_boid
centai84814783centai_
cento76625173cento__
centos85920463cento_s
centred103411683centred
centric11312403centric
centroids1247053centroids
ceratoid1149923ceratoid
cestoi84511953cestoi_
cestoids11308293cestoids
conoid9818883con_oid
ctenoid1078683cten_oid
cystoid13309213cystoid
deltoids1045483deltoids
demantoid1344623demantoid
dendroid1145923dendroid
denoted93512763denoted
dented84120513dent_ed
dentil74017883dent_il
dentin73919573dent_in
dermoid1138523dermoid
desmoid1137103desmoid
devoid1189363de_void
elytroid1244963elytroid
enfold10137613_enfold
enjoin1357833_enjoin
entail61114343_entail
entia5318203_ent_ia
entoiled968283_entoiled
entoils7810733_entoils
entomb1037363_entomb
entopic1149963_entopic
envoi878023_envoi_
envois988703_envois
factoid1338693factoid
fantod102010033fanto_d
fetid93715983fe_t_id
fungoid1245253fungoid
ganoid8314443gan_oid
gentil74115123gent_il
gentled9389093gentled
gentoo7311313gento_o
gentoos838633gentoos
geoid74215763ge__oid
hematoid1449753hematoid
hemoid12313513he_moid
hented104218753hent_ed
histoid1139823histoid
hyenoid1448613hyen_oid
keloid11812623ke_loid
kenotic1359713kenotic
keratoid1347273keratoid
labroid1038823labroid
languid936623languid
lectin82515013lect_in
lection92614863lection
lector83514993lecto_r
lectors93415773lectors
lemuroid11115173lemuroid
lend56233673len___d
lenis56326863len__is
lenited8812433lenited
lenition8310083lenition
leno47331393len_o__
lenos56024863len_o_s
lensed74015473len_sed
lent46360533lent___
lentando943603lentando
lenten6312883lent_en
lentigo846063lentigo
lentils73912973lentils
lentisk1136063lentisk
leotard846193leotard
leporid1048153leporid
leptin82512333lept_in
lepton82510803lepto_n
leptonic1247703leptonic
leptons91910433leptons
letted74118543le_tted
lianoid837533lianoid
linted74021823lint_ed
lintol6369473linto_l
lintols7339553lintols
lipoid9411043l_ipoid
lithoid1148773lithoid
loid55531503l___oid
lunted74517523lunt_ed
manatoid1148823manatoid
mantid93820383mant_id
mastoid10711233mastoid
mattoid1079283mattoid
meloid9616003me_loid
mention9314373mention
mentor8414363mento_r
mentored1138003mentored
mentors9314993mentors
negroid9108903negroid
neuroid81110313neuroid
nevoid1098803ne_void
odontoid1043553odontoid
pentad9313763pent_ad
pentode1039893pentode
pentomic1448153pentomic
pentose9311593pentose
pentoside1255383pentoside
pentoxide1944183pentoxide
peptid112712373pept_id
percoid12312323percoid
phytoid1678753phytoid
planetoid1245503planetoid
rented74426593rent_ed
renvoi945863renvoi_
renvois1036513renvois
retold73013753re_told
senti56226703sent_i_
sleazoid1843203sleazoid
solenoid947873solen_oid
tenfold1145713tenfold
tented74221003tent_ed
tentie62521183tent_ie
tentoria8119283tentoria
teratoid9411073teratoid
trendoid1045453trendoid
untold7149683_untold
ventail10310453ventail
vented104617923vent_ed
vetoed10359823ve_toed
zebroid1936473zebroid
zincoid1946663zincoid

Search took 10 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 Limit1340271558.87315105.0
3Display Results1551550.0463369.6
 (SQL Overall)1786911559.32519162.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.