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

133 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
dentinal93950(None) 
denial74720512den_i_al
denominal1245692denominal
dental74319172dent__al
dentil74017882denti__l
dentin73919572dentin__
dentine83320242dentin_e
dentines93418402dentines
denting94422182dentin_g
dentins83419222dentin_s
dentural948082dentural
encinal949242_encinal
identical1246312identical
retinal75318352re_tinal
sentinel838702sentinel
actinal9312293_actinal
adenoidal1143663adenoidal
aestival1145483aestival
agential958153agenti_al
agentival1353663agentival
anginal8310163_anginal
benthal1247953bent_hal
bestial9311643besti_al
cadential1246393cadenti_al
cantina93417253cantina_
cantinas102713773cantinas
cantonal1038903cantonal
cental84420963cent__al
central93114473cent_ral
centrical1348353centrical
continual1147143continual
datival1135583d_atival
decanal1038113de_canal
decimal1238083de_cimal
decrial10310323decri_al
deicidal1245713deicidal
deifical1445543deifical
deistical1246673deistical
demential1248683dementi_al
denials84114133den_i_als
denning93515173dennin_g
denoting10311753denotin_g
dentals83915393dent__als
denticle1137773denticle
dentiled1039743dentiled
dentils84115583denti_ls
dentist8316743denti_st
dentists939263dentists
denying123711293denyin_g
denyingly1744643denyingly
deprival1444603deprival
despisal1144673despisal
destine83719953destin_e
destined103312453destined
destines93619663destines
destiny113111463destin_y
detinue85010033de_tinue
detrital946573detrital
devisal1136913de_visal
devotional1444673devotional
dextral1577003dext_ral
dictional1268603dictional
dinting93520553dintin_g
doctrinal1243913doctrinal
duncical1345213duncical
dunting93418383duntin_g
encina8310443_encina_
encinas938723_encinas
enteral73516443_enteral
enthral103410933_enthral
entia5318203_enti_a_
estival1036323_estival
fentanyl1442533fentanyl
festival1444713festival
fetial95716193fe_ti_al
fontina1038633fontina_
fontinas1136853fontinas
geminal10109903ge_minal
genetical1247573genetical
genial74917613gen_i_al
genital849793gen_ital
genitival1343293genitival
gentian8310103genti_an
gentians937563gentians
gentil74115123genti__l
germinal1147253germinal
gestical1138983gestical
hectical1547933hectical
henting113719653hentin_g
ideational1146493ideational
intimal9109943_intimal
lenticel1066123lenticel
lentil64315393lenti__l
matinal9312603_matinal
menial84223033men_i_al
mental84521603ment__al
metical11315363me_tical
nonfinal1147703nonfinal
nontidal948673nontidal
nontonal849743nontonal
penial84120893pen_i_al
pentanol1046173pentanol
reginal84814293re_ginal
rental63922023rent__al
renting84026853rentin_g
retial64724993re_ti_al
retina65023383re_tina_
retinae75517333re_tinae
retinals85612963re_tinals
retinas74819353re_tinas
retinol7469693re_tinol
sectional1149413sectional
seminal91213403se_minal
sentinels947423sentinels
septical1259363septical
serotinal947213serotinal
sestina72711973sestina_
sestinas8249133sestinas
tegminal1144453tegminal
tensional946213tensional
tenting84621153tentin_g
terminal1039733terminal
tertial7313863terti_al
tetanal738023te_tanal
uncinal959963_uncinal
veinal93812963ve__inal
venatical1446793venatical
venial94218283ven_i_al
venting114218093ventin_g
ventral103612173vent_ral
vertical13410433vertical
xenial133414903xen_i_al
zenithal2093333zenithal

Search took 9 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.1531167915.0
2DLD Change Limit1461621338.12617987.0
3Display Results1331330.0632111.1
 (SQL Overall)1786911338.34221420.6
 
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.