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

112 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
civilly153548(None) 
cavally1588482cavally
chilly144113222c_hilly
civically1946562civically
civil103411932civi_l_
civility1646122civility
evilly1236592_evilly
lividly1434782lividly
uncivilly1743072uncivilly
vividly1744232vividly
airily93014823airi_ly
avidly13548783_avidly
bifidly1684233bifidly
billy105525363__billy
bivinyl1542733bivinyl
cagily12411563cagi_ly
cavalla1257883cavalla
cavalry1554963cavalry
cavil103816493cavi_l_
caviled1348723caviled
caviler1249063caviler
cavilled1436733cavilled
caviller1337063caviller
cavils114014393cavi_ls
cavity14310013cavi_ty
cecally1459393cecally
cedilla1036343cedilla
chally144314293c_hally
chicly16429203c_hicly
childly1644803c_hildly
chill105619873c_hill_
chilli114312773c_hilli
chillily1644113chillily
chills114717703c_hills
chivalry1943083chivalry
cicely1338833ci_cely
ciliary1247923ciliary
citify1437443citi_fy
civic123412543civi__c
civics13397823civi_cs
civie103716353civi__e
civies114116443civi_es
civilian1344453civilian
civilise1386263civilise
civilize22106393civilize
civism1337243civi_sm
civisms1436073civisms
civvy16435463civ__vy
clinally1347233clinally
coevally1646283coevally
coitally1339483coitally
colly104926773c__olly
coolly114811393c_oolly
cosily113613853cosi_ly
cozily20349703cozi_ly
cruelly1236563cruelly
cubicly1644993cubicly
cully105520463c__ully
curlily1238383curlily
devilry1433973devilry
dilly94923783__dilly
divinely1544993divinely
filially1447003filially
filly114424903__filly
finally13310103finally
frailly1337313frailly
frilly124111443_frilly
gilly94321633__gilly
hilly114422163__hilly
icily101211693_ici_ly
ickily1535753icki_ly
illy76925333___illy
jovially2144753jovially
levelly1335853levelly
licitly12276673licitly
livelily1444103livelily
lively123310813liv_ely
livingly1535633livingly
misally121111063misally
navally1366473navally
novelly1346513novelly
oilily93111723oili_ly
ovally12278443_ovally
privily15207623privi_ly
ravelly13268353ravelly
rigidly1235533rigidly
risibly1235643risibly
rivalry1354033rivalry
shrilly13318563shrilly
sillily10209783sillily
silly84527623__silly
stilly93714093_stilly
tidally1137933tidally
tidily102811393tidi_ly
timidly1334593timidly
tinily94014433tini_ly
trivially1545143trivially
vilely1239443__vilely
vill75235073__vill_
villa85321233__villa
villi86517853__villi
vills86429323__vills
virally1339653virally
virilely1444053virilely
visibly1535043visibly
vitally1339673vitally
vivify1834703vivi_fy
wavily15219483wavi_ly
weevilly1782623weevilly
wilily123310763wili_ly
willy115321913__willy
wirily123310783wiri_ly

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271126.62620227.4
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.07825246.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.