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

128 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
dentally12111006(None) 
mentally131010401mentally
centrally1448902centrally
deniably1448552deniably
dental74319172denta_l_
dentalia947532dentalia
dentality1348472dentality
dentals83915392denta_ls
dentately1344952dentately
dextrally2045112dextrally
distally1239552distally
festally1437542festally
genially12129522genially
genitally13127172genitally
menially131111092menially
penally121111772pen_ally
rectally1339712rectally
retally10413682re_tally
venally13119562ven_ally
venially1499422venially
ventrally1547252ventrally
vestally1437412vestally
adrenally1344943adren_ally
aerially11911913aerially
anally9513503_an_ally
annually1145833annually
banally1249223ban_ally
bestially1447053bestially
brutally1345743brutally
cecally1459393ce_cally
cental84420963centa_l_
centals94317053centa_ls
centaury1343953centaury
coitally1339483coitally
costally1339733costally
dally95324743d___ally
deadly113811473de__adly
deafly13389123de__afly
dearly104615323de__arly
deathly14336863deat_hly
debatably1754213debatably
decimally1745613decimally
deftly1336533deft__ly
delly96023873de___lly
denary105316863den_a_ry
deniable11312083deniable
denial74720513denia_l_
denials84114133denia_ls
denotable1238373denotable
densely1146713den_sely
dentalium1245333dentalium
dentate8315153denta_te
dentated10411703dentated
denticle1137773denticle
dentil74017883dent_il_
dentiled1039743dentiled
dentils84115583dent_ils
detail74516433de_tail_
details84214043de_tails
dewfall1453763dewfall_
dewfalls1543073dewfalls
digitally1445663digitally
dismally1446513dismally
dorsally1246833dorsally
dually103210063d__ually
ducally13257413d_ucally
edictally1545473edictally
entail61114343_entail_
entails7912823_entails
enterally12410013_enterally
enthalpy1642563_enthalpy
equally1936873_equally
eventually1644583eventually
fatally1339893_fatally
fentanyl1442533fentanyl
feudally1554823feudally
finally13310103fin_ally
frontally1546113frontally
generally1347343generally
genically151110173genically
genteelly1342663genteelly
gently103710913gent__ly
ideally1137793ide__ally
identically1748463identically
leally94012613le__ally
legally1138133le_gally
lethally1445923lethally
lineally1137793lineally
manually1347043manually
medially14129323medially
mental84521603menta_l_
mentality1449133mentality
mesally12119793me_sally
mesially13119083mesially
mortally1339933mortally
neonatally1352963neonatally
neurally1137933neurally
neutrally1246343neutrally
orientally1346213orientally
parentally1546203parentally
penalty1267743pen_alty
pentacle1239383pentacle
postally13310273postally
prenatally1544993prenatally
quantally2144063quantally
really93315613re__ally
regally1159873re_gally
rentable101716333rentable
rental63922023renta_l_
rentals74017473renta_ls
retrally11310523retrally
sensually1245313sensually
serially11912843serially
sexually1845613sexually
tally84526863___tally
tenably122210453ten_ably
tentacle1037693tentacle
tenthly1335743tent_hly
textually1944033textually
tonally10311373ton_ally
totally1039893_totally
vegetally1644213vegetally
ventail10310453ventail_
ventails1139823ventails
verbally1647183verbally
vernally1447823vernally
vitally1339673_vitally
zonally1938003zon_ally

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.440406115.9
2DLD Change Limit1461621287.82618676.5
3Display Results1281280.0462782.6
 (SQL Overall)1786911288.31221498.0
 
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.