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

129 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
genially1212952(None) 
genically151110171genically
genitally13127171genitally
menially131111091menially
venially1499421venially
aerially11911912aerially
deniably1448552deniably
dentally121110062dentally
geminally1576402geminally
generally1347342generally
genial74917612genia_l_
geniality1347162geniality
medially14129322medially
mentally131010402mentally
mesially13119082mesially
penally121111772pen_ally
serially11912842serially
venally13119562ven_ally
anally9513503_an_ally
animally1368643_animally
annually1145833annually
axenically2246803axenically
axially1737233_axially
banally1249223ban_ally
benignly1443213benignly
bestially1447053bestially
biennially1553523biennially
cecally1459393ce_cally
centrally1448903centrally
clinally1347233clinally
congenially1755903congenially
conically16312813conically
cranially1447893cranially
cynically1947253cynically
decimally1745613decimally
deniable11312083deniable
denial74720513denia_l_
denials84114133denia_ls
enviably1645353_enviably
epically15310583_epically
equally1936873_equally
eugenically1745843eugenically
evilly1236593_evi_lly
facially1637643facially
festally1437543festally
feudally1554823feudally
filially1447003filially
finally13310103fin_ally
finically1747953finically
gally95026173g___ally
gelidly1234753geli_dly
genealogy1442713genealogy
generalcy1543423generalcy
generically1747393generically
genetically1759203genetically
genital849793genital_
genitalia1044023genitalia
genitalic1243923genitalic
genitals937243genitals
genitivally1853513genitivally
genteelly1342663genteelly
gently103710913gen__tly
genuinely1342953genuinely
germinally1655253germinally
gilly94321633g__i_lly
gingall9117333gingall_
gingalls1096433gingalls
gingelly13305693gingelly
glacially1544583glacially
globally1444613globally
gnarly104610383g_n_arly
gyniatry1541863gyniatry
gyrally1435583g_yrally
helically1749433helically
irenically15710313irenically
jovially2144753jovially
labially1336983labially
leally94012613le__ally
legally1138133le_gally
lethally1445923lethally
lexically2146773lexically
lineally1137793lineally
manically16311703manically
manually1347043manually
medianly14125943medianly
medically17310113medically
menial84223033menia_l_
menials94015683menia_ls
mesally12119793me_sally
mesically16310093mesically
minimally1645903minimally
neurally1137933neurally
oedipally1543903oedipally
panically16310433panically
penalty1267743pen_alty
penial84120893penia_l_
racially1339623racially
radially1239783radially
really93315613re__ally
rectally1339713rectally
regally1159873re_gally
reliably1339243reliably
retally10413683re_tally
retrally11310523retrally
scenically1747943scenically
seminally1458803seminally
senilely1146113senilely
sensually1245313sensually
sexually1845603sexually
socially1338543socially
sonically14310953sonically
specially1647343specially
spinally1338023spinally
telically1449853telically
tenably122210453ten_ably
tenaille846813tenaille
tenurially1344083tenurially
tonally10311373ton_ally
tonically14311143tonically
uncially1339073uncially
venial94218283venia_l_
veniality1547593veniality
ventrally1547253ventrally
verbally1647183verbally
vernally1447823vernally
vestally1437413vestally
xenial133414903xenia_l_
xerically2149533xerically
zonally1938003zon_ally

Search took 7 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.470380193.6
2DLD Change Limit1461621296.45322650.2
3Display Results1291290.0632047.6
 (SQL Overall)1786911296.98625578.4
 
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.