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

296 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
levity127790(None) 
lenity9612711lenity
brevity1534782brevity
cavity14310012cavity
cecity1398152cecity
deity94316772de_ity
evite85317682_evite
ferity122813342ferity
laity85318902l_aity
laxity1637272laxity
lealty92910602lealty
lefty115613562le_fty
legit61323502legit_
legits71313002legits
lenite6719982lenite
levied104111432levied
levier94013872levier
levies93919862levies
levin84816412levi_n
levins94514652levins
levis85818552levi_s
levy106418502lev__y
verity123714852verity
acuity1139373acuity
aerify122810113aerify
aerily93017013aerily
alevin92511513alevi_n
alevins102110573alevins
alterity1149843alterity
amenity1238333amenity
amity10416093_amity
beauty115410163beauty
bedirty1344183bedirty
befit105222663befit_
befits114711503befits
beigy111110583be_igy
bevies114017303bevies
bevy127115223bev__y
celerity1347643celerity
cerite84724873cerite
city95122623__city
clarity12310913clarity
clerisy1246823clerisy
cleveite1343823cleveite
clevis1158963clevi_s
comity13312713comity
davit93424593davit_
davits104012363davits
debit85727853debit_
debits94214503debits
deify124112763de_ify
demit84832303demit_
demits94918073demits
density1137583density
deputy12426713deputy
deviate11312713deviate
device124512163device
devil94714733devi_l
devilry1433973devilry
devils104412813devils
deviltry1542983deviltry
devise104215753devise
devote104513783devote
dewily1338343dewily
dimity12310473dimity
edify12308563_edify
edit54934863_edit_
edits65819033_edits
eerily92913563eerily
elegit71212893elegit_
elegits8149343elegits
elevate101110373elevate
elite56230183_elite
elvish1277563elvish
emit65438423_emit_
emits75421473_emits
empty1247763_empty
enmity1137483enmity
entity9312053entity
equity1838103equity
every115215453_every
evict104417143_evict
evicts11368553_evicts
evil75318073_evi_l
evilly1236593_evilly
evils84114263_evils
evited104013143_evited
evites94916473_evites
exit114428673_exit_
exits125515913_exits
fealty122910223fealty
feisty12449293feisty
fixity19427803fixity
fruity12429693fruity
gleety10479193gle_ety
gravity1437183gravity
hearty126313633hearty
heavily1665903heavily
hefty146112133he_fty
invite93715033invite
jetty156212583je_tty
kevil12399863kevi_l
kevils13358333kevils
lacily11612763lacily
laith85722103l_aith
laving104623573laving
lavish124112983lavish
lazily1859713lazily
leachy14419733leachy
leady95618603le_ady
leafy116316213le_afy
leakily1436473leakily
leaky125217723le_aky
leally94012613leally
leanly93811503leanly
leant56737783leant_
leapt75027473leapt_
leary85927383le_ary
least56134883least_
leasts64616413leasts
leavier10319993leavier
leaving114216853leaving
leavy115715773le_avy
lectin82515013lectin
ledgy105712023le_dgy
leerily1037633leerily
leery85919133le_ery
leet45957903le_et_
leets54927123le_ets
leeway1255883leeway
left76340483le_ft_
lefts86517813le_fts
legacy1256653legacy
legality1237623legality
legate72917453legate
legato72810953legato
legerity1245713legerity
leggy105210243le_ggy
legibly1344623legibly
legion75712983legion
legist71315253legist
legists899593legists
lei36846383le_i__
leis45739603le_i_s
lemony11419553lemony
length1046103length
lengthy1452733lengthy
lenis56326863leni_s
lenited8812433lenited
lenites7818443lenites
lent46360533le_nt_
lentic83515743lentic
lentil64315393lentil
lento57223393le_nto
lept66440883le_pt_
lepta75714393le_pta
leptin82512333leptin
lesion64715063lesion
lest46956323le_st_
let36481473le__t_
lets47147943le__ts
leucite937753leucite
lev66139423lev___
leva77020713lev__a
levant9314493levant
levants1037723levants
levator10298963levator
levee84023813lev_ee
leveed104111373leveed
levees93714523levees
level84116553lev_el
levelly1335853levelly
levels94113283levels
lever85125163lev_er
levers94621323levers
leviers103510343leviers
levigate1246623levigate
levirate1147623levirate
levitate1137933levitate
levities11310713levities
levo76820063lev__o
levying1435873levying
lewdly1334403lewdly
lewis85315843lewi_s
lexica1536103lexica
lexis125916033lexi_s
ley66246813le___y
lezzy16608083le_zzy
licit74327683licit_
licitly12276673licitly
lily76730183l__ily
limit73126343limit_
limits82514143limits
limy95727713l__imy
linty87126563l_inty
liny78141323l__iny
lit39377313l__it_
lite47054543l__ite
lits46252493l__its
litu47631563l__itu
lively123310813lively
livery124910903livery
livid96714423livi_d
lividity1545083lividity
lividly1434783lividly
livier97514593livier
living104318323living
lofty115813303l_ofty
logily1039833logily
longevity1652393longevity
lovat8321043lovat_
lovats939073lovats
lovely12339713lovely
loving104416723loving
lucite8313343lucite
lusty85417573l_usty
meaty107021313me_aty
meiny104015413me_iny
melty104918363me_lty
merit7339183merit_
merits8320873merits
mity95528213__mity
nervily1336863nervily
netty85816763ne_tty
nevi75116423nevi__
nudity1037993nudity
obesity1275653obesity
oddity1135243oddity
parity114719873parity
peaty105725693pe_aty
pelite84323003pelite
periti8319953periti
pesty106421713pe_sty
petit74332653petit_
petite84320653petite
petty105320293pe_tty
pewit104622793pewit_
pewits112810683pewits
pity96031933__pity
plenty11311413ple_nty
polity113015863polity
privity15268313privity
purity114114913purity
rarity93615493rarity
reality10313573reality
realty92713693realty
recit75235103recit_
recite83625113recite
recits83621353recits
refit84230063refit_
refits94017653refits
reify114814973re_ify
relit55340683relit_
remit75737223remit_
remits85622943remits
resiny94617363resiny
resit54241043resit_
resite64128453resite
resits64725563resits
revery124014213revery
revet84938843revet_
revets94022173revets
review1238693review
revile94921613revile
revise94019743revise
revive124914823revive
revote94917453revote
sanity9316203sanity
seniti64317223seniti
seventy1338033seventy
severity1446973severity
sexily1638853sexily
sleety94112653sle_ety
suavity1336313suavity
tensity1039103tensity
tenty86121603te_nty
tenuity1037453tenuity
testy85419063te_sty
ulexite1445723ulexite
unity84918493_unity
uppity1335103uppity
vanity12311933vanity
veiny115414363ve_iny
velvety16304003velvety
verify153110163verify
verily122616053verily
verite94323443verite
viny106025953__viny
vita75828523__vita
vivify1834703vivify
wavily15219483wavily
weevily1694643weevily
whity145513473_whity
yeasty12438693yeasty
zenith1839073zenith
zesty176512163ze_sty

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162965.47020606.2
3Display Results2962960.0933182.8
 (SQL Overall)1786912965.93630102.9
 
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.