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 “sliver” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

152 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
sliver9411659(None) 
liver85132961_liver
shiver124517371shiver
silver93815811silver
siver85728611s_iver
skiver134612101skiver
slaver94419611slaver
slicer84117601slicer
slider73918361slider
slier54827241sli_er
slivers104115251slivers
stiver93915731stiver
aiver85725162_aiver
aliner65621982aliner
alive85722512alive_
claver113816972claver
clever114611532clever
clivers123411752clivers
clover114617122clover
deliver113312242deliver
diver94827802_diver
driver104714492driver
elver85216242el_ver
fiver116024942_fiver
flier86023402fli_er
flivver1633042flivver
giver94921202_giver
glider84614262glider
glover104513532glover
jiver155119052_jiver
laver85031792_laver
lever85125162_lever
liber74723612_liber
lier45942462_li_er
liever94611862_liever
lifer85822152_lifer
liger65024462_liger
liker95627062_liker
liner55938912_liner
liter54736342_liter
live76540992_live_
lived95523722_lived
liven85021732_liven
livers94927822_livers
livery124910892_livery
lives86133192_lives
livier97514592_livier
livre85613252_livre
livyer12426292_livyer
lover85526452_lover
naiver94311352naiver
olive84817152olive_
olives94313952olives
plier75221282pli_er
plover115312612plover
quiver18278742quiver
reiver95318292reiver
river85731692_river
sailer63526102sailer
salver94617752salver
saver84831252s_aver
seiner64622482seiner
seiser65318342seiser
seizer154114572seizer
server94917712server
sever85426052s_ever
shaver123718912shaver
shier85428942shi_er
shiner93820872shiner
shive114423422shive_
shivers133714832shivers
shivery16317022shivery
shives124921412shives
shover124515982shover
shriver134712192shriver
siker95326032s_iker
siller64026052siller
silvern10347132silvern
silvers104714032silvers
silvery13328092silvery
silvex16336722silvex
sivers95324152s_ivers
sizer145521812s_izer
skier95119592ski_er
skive124614112skive_
skived14429892skived
skivers14409692skivers
skives134113942skives
slaker104219272slaker
slater64429182slater
slave84224032slave_
slaved104017042slaved
slavers103716502slavers
slavery13407892slavery
slaves95023022slaves
slavey124011802slavey
slayer93916332slayer
slice74925822slice_
sliced94416312sliced
slicers94114922slicers
slices84022852slices
slicker133314532slicker
slide64725412slide_
sliders83515222sliders
slides73922182slides
slieve9359272slieve
slieves10378962slieves
slime74925752slime_
slimed94915122slimed
slimes84722042slimes
slimier93212012slimier
slimmer114211342slimmer
slinger83413822slinger
slipe75626132slipe_
sliped95417062sliped
slipes84921412slipes
slipover1343832slipover
slipper113712972slipper
slither104112982slither
slitter73615872slitter
slivered12218102slivered
sliverer11237632sliverer
sloper84615912sloper
sloven9389632sloven
slower94016152slower
slyer85515122sl_yer
smiler83916682smiler
smiter83616412smiter
snider74413912snider
sniper84413642sniper
snivel9368852snivel
soever94412092soever
solider82912452solider
solver94016702solver
spicer104719312spicer
spider94516802spider
spier75728032spi_er
spiker124315662spiker
splicer114710522splicer
stivers103613532stivers
stover94115642stover
striver104315202striver
stuiver10447082stuiver
suaver93014232suaver
suiter64121812suiter
swive115316192swive_
swived133610632swived
swivel12369322swivel
swives123915182swives
swivet123615472swivet
waiver124212712waiver
wiver115924512_wiver

Search took 4 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 Filter178691825510.1231452772.4
2DLD Change Limit825511522.93628116.8
3Display Results1521520.0463304.3
 (SQL Overall)1786911523.10557549.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.