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

131 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
venially149942(None) 
genially12129521genially
menially131111091menially
venally13119561ven_ally
aerially11911912aerially
deniably1448552deniably
dentally121110062dentally
genically151110172genically
genitally13127172genitally
medially14129322medially
mentally131010402mentally
mesially13119082mesially
penally121111762pen_ally
serially11912832serially
venial94218282venia_l_
veniality1547592veniality
ventrally1547252ventrally
verbally1647182verbally
vernally1447822vernally
vestally1437412vestally
anally9513503_an_ally
animally1368643_animally
annually1145833annually
axenically2246803axenically
axially1737233_axially
banally1249223ban_ally
benignly1443213benignly
bestially1447043bestially
biennially1553523biennially
cecally1459393ce_cally
centrally1448893centrally
clinally1347233clinally
conically16312813conically
cranially1447893cranially
cynically1947253cynically
decimally1745613decimally
deniable11312083deniable
denial74720513denia_l_
denials84114133denia_ls
enviably1645353_enviably
epically15310573_epically
equally1936863_equally
evenfall1492943evenfall_
evenfalls1562673evenfalls
eventually1644573eventually
evilly1236593_evi_lly
facially1637643facially
festally1437543festally
feudally1554823feudally
filially1447003filially
finally13310103fin_ally
finically1747953finically
geminally1576393geminally
generally1347343generally
genial74917613genia_l_
geniality1347163geniality
helically1749433helically
irenically15710313irenically
jovially2144753jovially
labially1336983labially
leally94012613le__ally
legally1138133le_gally
lethally1445923lethally
lexically2146773lexically
lineally1137793lineally
manically16311693manically
manually1347043manually
medianly14125943medianly
medically17310103medically
menial84223033menia_l_
menials94015683menia_ls
mesally12119793me_sally
mesically16310083mesically
minimally1645893minimally
neurally1137923neurally
oedipally1543903oedipally
panically16310433panically
penalty1267743pen_alty
penial84120893penia_l_
racially1339623racially
radially1239783radially
really93315613re__ally
rectally1339713rectally
regally1159873re_gally
reliably1339243reliably
retally10413683re_tally
retrally11310523retrally
scenically1747943scenically
seminally1458793seminally
senilely1146093senilely
sensually1245313sensually
sexually1845603sexually
socially1338533socially
sonically14310933sonically
specially1647343specially
spinally1338013spinally
telically1449853telically
tenably122210453ten_ably
tenaille846803tenaille
tenurially1344083tenurially
tonally10311373ton_ally
tonically14311123tonically
uncially1339073uncially
vagally1435833v_agally
vaginally1645233vaginally
vanilla10238743vani_lla
variably1637433variably
vealy115817773ve__a_ly
vegetally1644213vegetally
veinal93812963veina_l_
venal85523213ven_a_l_
venality1438683ven_ality
vendable14159693vendable
vendibly17174473vendibly
venerably1746423venerably
venously1445663venously
ventail10310453ventail_
ventails1139823ventails
verily122616053veri__ly
veritably1746543veritably
vertically18410913vertically
vexilla1744663vexi_lla
vexingly2244663vexingly
viably14199833v__iably
virally1339643v_irally
visually1465493visually
vitally1339673v_itally
vocally15188343v_ocally
xenial133414903xenia_l_
xerically2149523xerically
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.1561145455.1
2DLD Change Limit1461621318.45317291.1
3Display Results1311310.0462847.8
 (SQL Overall)1786911318.65520646.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.