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

126 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
jollity174614(None) 
jollify2044261jollify
jollily1745771jollily
jellify2054542jellify
jollied15349272jollied
jollier142911002jollier
jollies143516272jollies
jolly154517512joll__y
joltily1746322joltily
jolty155713032jo_l_ty
molality13118362molality
mollify1555502mollify
nullity1037362nullity
polity113015862po_lity
ability12311443ability
agility1148653agility
anality10313633anality
anility10312723anility
bolling103820883bolling
bollix1538053bolli_x
coalify1536683coalify
collate92919683collate
collet84030363collet_
collets93517903collets
collide103214793collide
collie83621993colli_e
collied103316673collied
collier93618153collier
colliery13307363colliery
collies94326583collies
collins93419833collins
colly104926773coll__y
comity13312713co_mity
docility1447123docility
dollied93811143dollied
dollies83620983dollies
dolling93817373dolling
dollish11610093dollish
dolly96125203doll__y
duality1147963duality
eolith93013903eo_lith
falsity1335903falsity
follies103618943follies
follis93113903folli_s
folly115022603foll__y
godlily1235343godlily
golly95121103goll__y
holily123612953ho_lily
hollies103420813hollies
holly114824433holl__y
hoplite12311073hoplite
illite63414923_illite
iolite63221983io_lite
jellied15419223jellied
jellies143816533jellies
jelling153516613jelling
jelly154218253jell__y
jillion14188933jillion
jocosity2044343jocosity
jokily20306533jo_kily
jolliers15357433jolliers
jolliest152910363jolliest
jollities1647873jollities
jollying19316053jollying
jolt116639123jo_l_t_
joltier14318493joltier
jolting153410913jolting
jolts125018883jo_l_ts
jotty155012603jo__tty
joviality2244133joviality
jowlier17327563jowlier
jowly186410903jowl__y
laity85318903__laity
locality13148433locality
lollies73116923lollies
lolling83415773lolling
lollopy12234773lollopy
lolly85120663loll__y
lowlily1335353lowlily
mobility1548543mobility
modality14117653modality
molarity13118903molarity
mollie83517103molli_e
mollies93420233mollies
molly105222493moll__y
morality131110333morality
motility1338733motility
mullite9313013mullite
nobility1348983nobility
nodality12127423nodality
nullify1334713nullify
oddity1135243_oddity
oilily93111723_oilily
oolite63319603_oolite
oolith93813243_oolith
orality101111683orality
ovality1377593ovality
polarity131310403polarity
policy133211513po_licy
polite83625073po_lite
polling102920383polling
pollist9816603pollist
pollists10910823pollists
pollute937383pollute
quality1938563quality
reality10313573reality
rollick1335613rollick
rollicky1742693rollicky
rolling83620413rolling
rollway1344653rollway
sillily10209783sillily
sodality12127323sodality
solidity1248113solidity
tallit63422733tallit_
tallith102913063tallith
tallits73215993tallits
tillite7313563tillite
tolling83418563tolling
tollway1344793tollway
tonality1139793tonality
totality1139373totality
utility1038703utility
velleity1443743velleity
vocality16137933vocality
volley12419743voll_ey
woollily1443123woollily

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271266.17321711.8
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.60927037.5
 
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.