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

189 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
lithely135664(None) 
blithely16104031blithely
dithery14318942dithery
laithly1335652laith_ly
lately93413842lat_ely
lathery133911122lathery
lichtly15255522lichtly
lightly14369022lightly
likely13328132li_kely
lithe84922012lithe__
lither94520952lithe_r
lithest10513912lithest
lithify1644762lithify
littery103710492littery
lively123310812li_vely
pithily1567032pithily
slithery14356702slithery
astheny1345293astheny
bethel1169643bethel_
bethels1238533bethels
bitchery18236563bitchery
bitchily1844533bitchily
bitterly1335603bitterly
blithe115810863blithe__
blither124812173blithe_r
blithers134711233blithers
blithest1338083blithest
cicely1338833ci_cely
cither114616683cithe_r
cithern12489913cithern
cithers124315773cithers
cutely115312803cut_ely
direly10311563di_rely
dishelm1335833dishelm
dither104417683dithe_r
dithers114016153dithers
either94517423eithe_r
fatherly1745073fatherly
fifthly1943093fifth_ly
filthily1743663filthily
finely123011563fi_nely
fishery16397733fishery
fishily1637643fishily
fitly115114973fit__ly
gingely12378213gingely
glittery12375613glittery
highly1636823high_ly
hither124417253hithe_r
itchily1574493_itchily
ither84617603_ithe_r
itself946263_itself
jitney16304623jitne_y
jittery17346443jittery
kithe125917453kithe__
kithed144613013kithe_d
kithes135016653kithe_s
kittel10368873kittel_
lamely114013223l_amely
lanely93914483l_anely
largely1136703largely
lathe85626723lathe__
lathed104718463lathe_d
lather95124363lathe_r
lathers104321883lathers
lathes95127503lathe_s
lathy115215063lath__y
latterly1136063latterly
leathery14438973leathery
lechery15257643lechery
lethal939803lethal_
lethally1445923lethally
lethals1038113lethals
lethe85717303lethe__
lethean1037093lethean
lethes94818083lethe_s
libel74116103li_bel_
libels85112693li_bels
lichee114017973liche_e
lichees123512783lichees
lichen114012743liche_n
lichens123510683lichens
liches114724293liche_s
licitly12276673licitly
liefly1266363li_efly
lily76730183li___ly
limberly1544463limberly
limey104721043li_me_y
limply133810033li_mply
lineny94011443li_neny
liney87029633li_ne_y
linsey938993linse_y
lintel64013993lintel_
lintels73311163lintels
liquefy2243013liquefy
listel64214743listel_
listels74212433listels
litany939053lit_any
lite47054543lit_e__
liter54736343lit_e_r
liters65429883lit_ers
lithemia1345253lithemia
lithemic1545593lithemic
lithia939333lith_ia
lithias1038823lithias
lithic1139493lith_ic
lithium1245823lithium
litho86513783lith__o
lithoed1137833lithoed
lithoid1148773lithoid
lithology1645443lithology
lithops12307253lithops
lithos94212553lith_os
litre55421463litre__
litres65220393litre_s
litten64014873litte_n
litter64324853litte_r
litters73422573litters
little63312163lit_tle
littler7348553littler
littles73212783littles
liturgy1142873liturgy
livery124910903li_very
lividly1434783lividly
loathly1334713loath_ly
lonely92912473l_onely
loosely1036723loosely
lottery10389833lottery
lovely12339713l_ovely
lushly12247343lush_ly
luthern1037653luthern
misrely12319613misrely
mither114218563mithe_r
mithers123516733mithers
motherly16346093motherly
mothery153710513mothery
mutely113811653mut_ely
nicely1139493ni_cely
nightly14449033nightly
ninthly1344213ninth_ly
nitery94412173nit_ery
pitchily1855013pitchily
pithead13419593pithead
pithed124615613pithe_d
pithy135614463pith__y
politely1347093polit_ely
richly1438013rich_ly
rifely123710033ri_fely
rightly14389043rightly
ripely112511153ri_pely
ritzily1945143ritzily
sightly14408273sightly
sithens1039383sithens
sixthly2042873sixth_ly
slightly1544603slightly
slither104112983slithe_r
slithers114212953slithers
smithery16325703smithery
steely93612573_steely
swithly1634443swith_ly
thewy146311853__thewy
they107223753__the_y
tightly14327613tightly
timely113410113ti_mely
tithe85319703tithe__
tithed104115593tithe_d
tither94920283tithe_r
tithers104216733tithers
tithes94720213tithe_s
tritely1039003trit_ely
vilely1239443vi_lely
vitally1339673vitally
whitely16346473whit_ely
widely133311033wi_dely
wifely15429423wi_fely
wisely122711713wi_sely
witchery19236093witchery
withal1238933withal_
withe115220233withe__
withed134416233withe_d
wither124321353withe_r
withers134417753withers
withes124620843withe_s
withheld1842353withheld
withy144813763with__y
witney12356843witne_y
wittily1336173wittily
zither183813083zithe_r
zithern19447023zithern
zithers193911973zithers

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 Limit1340271896.23321502.8
3Display Results1891890.0633000.0
 (SQL Overall)1786911896.68626726.1
 
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.