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

109 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
comically1831052(None) 
conically16312811conically
cosmically1948021cosmically
domically1749101domically
atomically1749872atomically
chemically2248312chemically
civically1946562civically
coitally1339482co_itally
comedically2156992comedically
comical13312222comica_l_
comicality1946132comicality
cortically17411822cortically
cubically1846142cubically
cynically1947252cynically
iconically1769272iconically
logically1548972logically
nominally1446802nominally
ohmically1946902ohmically
osmically1647322osmically
sonically14310952sonically
tonically14311142tonically
topically1649532topically
toxically2147572toxically
alogically1648793alogically
amicably1746333_amicably
anemically1748903anemically
anodically1648263anodically
antically14315683antically
apically1539833_apically
basically1648033basically
bucolically2053933bucolically
caecally1547703c_aecally
calorically1847773calorically
canonically1847623canonically
capitally1646663capitally
cecally1459393c__ecally
chaotically2148453chaotically
chronically2147803chronically
clerically1748193clerically
clinally1347233c_linally
clinically1747073clinically
coastally1446503coastally
coaxially21144573coaxially
coequally2344043coequally
coevally1646283co_evally
communally1945003communally
compactly2043823compactly
confocally2044343confocally
conical11316203conica_l_
cordially1547483cordially
coronally1448413coronally
cosmetically2147933cosmetically
cosmical1448013cosmica_l_
costally1339733co_stally
criminally1746193criminally
critically17411273critically
crucially1645443crucially
cyclically1944913cyclically
domical1239373domica_l_
economically2156803economically
ectopically2047123ectopically
epically15310583_epically
erotically15414313erotically
ethically1748713ethically
exotically2249493exotically
filmically2044933filmically
finically1747953finically
focally15188553fo__cally
geminally1576403geminally
genically151110173genically
gothically1946713gothically
helically1749433helically
homicidally2252023homicidally
inimically1747913inimically
ironically151110543ironically
jovially2144753jovi_ally
laconically1846533laconically
laically1338983_laically
lexically2146773lexically
locally12179723lo__cally
lyrically1746773lyrically
lytically1757383lytically
magically1748963magically
manically16311703manically
medically17310113medically
mesically16310093mesically
misally121111063__misally
mosaically1747423mosaically
musically1647853musically
myopically2246173myopically
ontically14311843ontically
optically1649903optically
panically16310433panically
phonically2049023phonically
photically20411173photically
poetically17412883poetically
polemically2047643polemically
radically15310423radically
scenically1747943scenically
seminally1458803seminally
socially1338543soci_ally
somatically18411153somatically
stoically1449673stoically
telically1449853telically
tropically1749843tropically
typically1946083typically
vocally15188343vo__cally
vortically1849193vortically
xerically2149533xerically

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411097.95318689.9
3Display Results1091090.0631730.2
 (SQL Overall)1786911098.46921099.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.