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

197 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
lissom83740(None) 
lissome937581lissome
blossom11114962blossom
lasso55015682lasso_
lassos64913812lassos
lesson64412042lesson
lessor64010602lessor
lissomly1372772lissomly
wisdom1235982wisdom
alyssum1242473alyssum
basso76017283basso_
bassos85313703bassos
besom95716973_besom
bishop1336943bishop
bison75716983bi_son
bliss75616913bliss__
blissed10388373blissed
blisses94911513blisses
blossoms12134553blossoms
blossomy15113203blossomy
bosom95516923_bosom
bossdom1244243bossdom
caisson936593caisson
cisco95112133cisco_
ciscos104711133ciscos
cissoid1037343cissoid
cissy104811073ciss_y
classon937693classon
crissum1144843crissum
cusso74912293cusso_
cussos84210003cussos
custom104010273custom
diatom939453diatom
dipso85111553dipso_
dipsos95310053dipsos
disarm9310473disarm
disbosom1344303disbosom
disco85616073disco_
discos94915213discos
diss56434493diss__
dissed85220183dissed
disses75225963disses
distome10313233distome
elision72311103elision
fission1038733fission
frisson1045313frisson
gesso649603gesso_
gibson935123gibson
gismo848863gismo_
gismos957183gismos
hansom11219153hansom
hiss75629223hiss__
hissed104114453hissed
hisser94713793hisser
hisses94719353hisses
hissy116112123hiss_y
hyssop1443413hyssop
idiom899963_idiom
ism56322393_i_s_m
issei568573_issei
issue559213_issue
jetsom15126143jetsom
jism135514783ji_s_m
kiss85227413kiss__
kissed114412853kissed
kisser104212453kisser
kisses104217333kisses
kissy125510323kiss_y
kusso9398033kusso_
kussos10336423kussos
lass47444543lass__
lasses64827593lasses
lassi56316853lass_i
lassie64917743lassie
lassis65216703lassis
lassoed8408743lassoed
lassoer7379383lassoer
lassoes74613853lassoes
lesbo739253lesbo_
lesbos837403lesbos
lesion64715063lesion
less45635103less__
lessee64116363lessee
lessen64212433lessen
lesser63514853lesser
lessons73811023lessons
lessors73610523lessors
lewisson1142023lewisson
liaison744473liaison
libs66732773libs__
lictor83610863lictor
lido56028173li_do_
lidos65219893li_dos
lids56336473lids__
lies46454203lies__
lilo46731573li_lo_
lilos55821873li_los
limbo95614813limbo_
limbos104712143limbos
limo65529743li_mo_
limos75320813li_mos
lingam95112353lingam
lingo66022113lingo_
lino46343383li_no_
linos55631503li_nos
lins47059063lins__
linsey938993linsey
lintol6369473lintol
linum7313823li_num
lion46334453li__on
lipoma1046753li_poma
liposome1246013liposome
lips67141453lips__
liquor1534203liquor
lirot5430033li_rot
lis37162283li_s__
lisle53916723li_sle
lisles63416283lisles
lisp68926893li_s_p
lisped94113423lisped
lisper84114433lisper
lisps76913913li_sps
lissomely14113113lissomely
list47055353li_s_t
listed74322833listed
listee64223063listee
listel64214743listel
listen64816813listen
lister64527253lister
lists56628693li_sts
litho86513783litho_
lithos94212553lithos
lits46252503lits__
loom67035053l__oom
loss45337963loss__
losses65925233losses
lossy85214643loss_y
lysosome1344563lysosome
lyssa835713lyss_a
lyssas935443lyssas
miasm91211093mias_m
misaim10311853misaim
misdo85413193misdo_
misform1437513misform
miso67229913mi_so_
misos76523293mi_sos
miss65339433miss__
missal84314903missal
missay114112143missay
missed94423603missed
missel85216523missel
misses85130873misses
misset85028153misset
misshod1335873misshod
mission9312743mission
missis84417503missis
missort9314653missort
missout9412663missout
misstop11156413misstop
missus85312293missus
missy105617563miss_y
mosso74715183mosso_
passim10410283passim
pisco96314983pisco_
piscos105112593piscos
piso66727573pi_so_
pisos76021063pi_sos
piss65033343piss__
pissed94816933pissed
pisser84416383pisser
pisses84525083pisses
pissoir945043pissoir
pistol83313333pistol
piston83515923piston
pistou83211843pistou
plessor9317693plessor
plimsol1143343plimsol
plisse8368403pliss_e
plisses94411773plisses
possum1057953possum
ransom82410943ransom
rissole739783rissole
scissor994123scissor
simoom1037503simoom
sisses64520603sisses
sissy85812073siss_y
sitcom1036903sitcom
som59153813___som
tissue637333tissue
tussor6378233tussor
vision9311313vision
visor82512833vi_sor
winsome1237463winsome
wisdoms1335453wisdoms
wiss75630553wiss__
wissed104114643wissed
wisses94619603wisses

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 Filter1786911127160.393454684.5
2DLD Change Limit1127161977.07615929.3
3Display Results1971970.0633127.0
 (SQL Overall)1786911977.53223724.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.